Softpedia >Windows >Internet >Servers >Database Utils >MicroOLAP Database Designer for PostgreSQL >  Changelog

MicroOLAP Database Designer for PostgreSQL Changelog

What's new in MicroOLAP Database Designer for PostgreSQL 1.16.1173

Jul 19, 2021
  • PostgreSQL 13.3 libraries added
  • "EXCLUDE constraint without name generated wrong" fixed
  • "UNIQUE constraint without name generated wrong" fixed
  • EAccessViolation during selection of Fields column in the Constraint Manager fixed
  • ERangeError during unknown type import from MSAccess fixed
  • ERangeError for cancelled "Select a constraint" dialogue fixed
  • Reference constraint ID field now saved after Reverse Engineering

New in MicroOLAP Database Designer for PostgreSQL 1.15.1 (Nov 13, 2019)

  • PostgreSQL 12 support added
  • OIDs ignored during Reverse Engineering from version 12 and above
  • pg_attrdef.adbin column used for Reverse Engineering now, since pg_attrdef.adsrc is deprecated

New in MicroOLAP Database Designer for PostgreSQL 1.14.0 (Dec 31, 2018)

  • This release introduces preliminary support for PostgreSQL v11

New in MicroOLAP Database Designer for PostgreSQL 1.13.1 (Jun 27, 2018)

  • Due to major bug found in the installer Database Designer for PostgreSQL 1.13.1 hotfix available.

New in MicroOLAP Database Designer for PostgreSQL 1.12.3 (Mar 8, 2018)

  • CREATE TYPE output for ENUMs improved
  • Object Tree opens editor on Enter key
  • Object Tree returns focus after editors closing
  • "Cannot open file. The system cannot find the file specified" bug fixed for SQL Editor
  • "EVariantTypeCastError error during Autoinc property edit in Table Editor" bug fixed
  • "Reverse Engineering of functions with more than 255 parameters failed" bug fixed
  • "Reversed Enum types with spaces in labels saved with extra quotes" bug fixed
  • "Some edits in Stored Routine Editor have wrong positions on resize" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.12.2 Build 1140 (Jan 18, 2018)

  • Identity columns support added
  • OpenSSL 1.1.0g libraries used
  • New icons added for editors tabs
  • Application font size input placement fixed in Environment Options

New in MicroOLAP Database Designer for PostgreSQL 1.11.3 Build 1070 (Aug 5, 2016)

  • "Don't run, just save" option added to Generate and Modify
  • "Run default application associated with .sql files" option added to Generate and Modify
  • HideShow objects functionality added
  • String constants highlighted blue in SQL scripts
  • UUID type is highlighted as type in SQL scripts
  • "ERangeError during CHECK constraint editing" bug fixed
  • "Model name not properly loaded from file" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.11.2 Build 1065 (Jul 6, 2016)

  • This is maintenance release focused on tuning bug reports facility.

New in MicroOLAP Database Designer for PostgreSQL 1.11.1 Build 1064 (May 26, 2016)

  • Reference label position can be changed by user now
  • User can add, move and remove custom points of references now
  • User can move the start and the finish points of references now
  • "Cannot turn off Snap to Grid" bug fixed
  • "Cannot turn off Show Grid" bug fixed
  • "Index list out of bounds" rare display bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.10.6 Build 1047 (Oct 16, 2015)

  • Anonymous statistics module added (optional)
  • Enhanced Windows 10 support by new compiler introduced
  • Performance optimizations in error logging
  • "EAccessViolation (Bug B21C0000) after reference deletion" bug fixed
  • "Range check error in processes information for x64 machines" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.10.5 Build 1044 (Jul 30, 2015)

  • Error logging improved a lot
  • Support for columns with special characters in names added to indexes and constraints
  • Adding sequences with the same name but different schemas allowed now
  • "Access Violation occurs after deleting diagram object and clicking on empty diagram space" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.10.4 Build 1037 (Apr 8, 2015)

  • Dramatically increased Reverse Engineering speed
  • "Add object" menu item is available for Domains and Sequences in the Object Tree View
  • Manager tool bar is enabled automatically after new model created
  • "Cannot open model (.pdd) file in Explorer if application already launched" bug fixed
  • Temporal types have no precision specifier in new domains by default from now

New in MicroOLAP Database Designer for PostgreSQL 1.10.3 Build 1031 (Apr 8, 2015)

  • PostgreSQL 9.4 support added
  • Allow creating indexes CONCURRENTLY using Modify script
  • JSONB type support added
  • Primary column removed from Column Manager
  • Support for ENUM types improved in Column Manager
  • uuid[] type added to editors
  • "Quote Default Value option not saved in Column Manager" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.10.2 (Dec 23, 2014)

  • "Access Violation error occurs if Run New Database Wizard option is checked in the Generate Database" bug fixed
  • "Index fields popup editor deselects all previously checked columns" bug fixed
  • Check Diagram makes Output and Result List visible
  • Check Diagram doesn't show index warnings for tables with PK's or Unique constraints anymore

New in MicroOLAP Database Designer for PostgreSQL 1.10.0 Build 1016 (Jul 5, 2014)

  • SQL Executor and Validator support v9.4 grammar now
  • Support for table inheritance improved dramatically
  • "Always make PK columns first" option introduced in Diagram Options
  • Allow CHECK constraints to be declared NOT VALID in Modify script
  • Allow FOREIGN KEY constraints to be declared NOT VALID in Modify script
  • Shortcut for "Save As.." and "Export" menu items added
  • SQL keywords are properly highlighted according to 9.4 version
  • Comments now shown at Preview tab of Table Editor by default
  • Handling of incorrect file paths improved in Generate and Modify Database
  • Merging of reversed user types with existing in model improved during Reverse Engineering
  • "Changing domain schema doesn't affect table representation where domain used" bug fixed
  • "Changing some options in the Model Options doesn't activate OK & Apply buttons" bug fixed
  • "Column default values containing backslashes are corrupted after reloading model" bug fixed
  • "Leak proof option doesn't shown in the Function editor after reopen" bug fixed
  • "LEAKPROOF attribute causes syntax error in the SQL Executor" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.9.2 Build 988 (Oct 24, 2013)

  • Several models may be passed through command line for opening
  • Support added for Element property of scalar types
  • Added missing carriage return at the end of tables statements in the Modify Database script
  • Error messages improved in the SQL Executor
  • Find Objects result tree now contains proper images for objects found
  • Object editor may be open pressing Enter in Find Objects dialog
  • Opening SQL Executor will create empty model if needed
  • Processing of tables improved in the Modify Database
  • SQL parser improved to prevent out of range errors
  • Statement Error dialog opens at the owner window center from now
  • Subject corrected for exception tracer messages
  • Tab order fixed in the Generate and Modify dialogs
  • "ERangeError occurs when mouse selection area leaves model bounds" bug fixed
  • "Generate and Modify dialogs: Columns Default Values option is enabled even if Create Table unchecked" bug fixed
  • "Generate and Modify dialogs: Rules option is enabled even if Create View unchecked" bug fixed
  • "Index out of bounds possible error prevented for views in Database Modify" subj fixed
  • "Model file passed through command line (double clicked in Explorer) doesn't open" bug fixed
  • "Modify Database produce COMMENT statements even if option unchecked" bug fixed
  • "Modify Database produce TRIGGER statements even if option unchecked" bug fixed
  • "Range check error when generating SQL with scalars without in\out functions" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.9.1 Build 926 (Aug 13, 2013)

  • "Case insensitive name comparison" option added to Modify Database
  • Materialized views support added
  • Recursive views support added
  • Width and Height properties displayed for the selected object in the status bar from now
  • Calculations for objects width improved
  • Comparison of function parameters improved in the Modify Database
  • Generate and Modify dialogs now allow change file name if it's already exist after confirmation cancelling
  • Modify Database shows "No modification found" dialog now instead of empty "Execute SQL Query" dialog
  • Processing of views improved in the Modify Database
  • "Cannot create objects with the same name but different text case" bug fixed
  • "Column Manager may change fields order if list column was sorted" bug fixed
  • "Modify Database doesn't produce DROP VIEW statements even if option is selected" bug fixed
  • "Schema and name separator is missing in ALTER TABLE RENAME statements in Modify scrpits" bug fixed
  • "Select\Deselect All buttons don't work for Stored Routines list in the Database Generation and Modify dialog" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.9.0 Build 919 (May 23, 2013)

  • New compiler used in development
  • New exception tracer tool used
  • "Designer doesn't restore itself to maximized state after restart" bug fixed
  • "Modify Database ignores output script character case option" bug fixed
  • "Reverse Engineer warns that diagram is not empty even though it clearly is" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.8.5 Build 874 (Dec 27, 2012)

  • Support for domains with multiple constraints added
  • Empty index attributes are now rejected in the Table Editor
  • Undo/Redo functionality now works for "Quick Insert" actions in the Advanced SQL Editor
  • "DROP clause not generated for tables, views and SPs before CREATE statement if such options selected" bug fixed
  • "New column's COMMENT clause not generated for Modify script" bug fixed
  • "New reference's changes lost if Apply followed by Cancel pressed in the Reference Editor" bug fixed
  • "Reverse of the domain with several constraints failed" bug fixed
  • "Saving Leakproof parameter may corrupt ExecutionCost data of stored routine" bug fixed
  • "SQL Reverse Engineering fails for long index names" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.8.4 Build 860 (Sep 28, 2012)

  • LEAKPROOF function specification added
  • security_barrier option added for views
  • SMALLSERIAL data type added
  • "Cannot clear CHECK clause for DOMAIN in the UDT Editor" bug fixed
  • "Drag-and-drop multiple selected items causes all to go in top left hand corner" bug fixed
  • "Reverse Engineering of tablespaces broken in PostgreSQL 9.2" bug fixed
  • "Temporary property of views is not saved" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.8.1 Build 818 (Sep 21, 2011)

  • Name patterns for newly created objects supported
  • Object selection added to Create HTML Report dialog
  • Support for unlogged tables using the UNLOGGED option added
  • Additional checks added for dependent composite types during model loading
  • Improved processing for fields deletion with referenced foreign keys in Modify engine
  • Syntax highlightning improved for base types
  • "Access violation on Privilege Manager Add button click" bug fixed
  • "Cannot cast type text[] to text error duting Reverse Engineering on pre-8.2 servers" bug fixed
  • "EInvalidCast error occurs during deletion of domain in Domain & UDT Manager" bug fixed
  • "Relation 'pg_users' does not exist during Reverse Engineering on pre-8.1 servers" bug fixed
  • "Some sequences may not be generated using Generate Database dialog" bug fixed
  • "Stamp colors are not saved" bug fixed
  • "Stored Routine Editor dissalows non-latin character in routine name" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.8.0 Build 800 (Aug 16, 2011)

  • Unicode support added
  • "Include version to Generate & Modify scripts file names" option added to Diagram Properties dialog
  • Import and Export for connection profiles added
  • Support for stored routines default parameters values added to Reverse Engineering engine
  • Updated printing system introduced
  • Composites, scalars and enums are listed in Object Tree from now
  • Model version auto incrementation improved
  • "Cannot set empty values for some options in right detail panels in the Table Editor" bug fixed
  • "Constraint Manager duplicates columns in PK constraints" bug fixed
  • "Create a connection profile for the new database option ignored in New Database Wizard" bug fixed
  • "Modify Database ignores Autoinc flag of model columns" bug fixed
  • "Some nodes collapse in Object Tree View if it looses focus" bug fixed
  • "String constants with Unicode characters (>$FF) may not pass validation in Execute SQL Query dialog" bug fixed
  • "Texts are missing in PDF export" bug fixed
  • "Wrong order of added columns in Modify Database result script" bug fixed
  • SLL connections fixed

New in MicroOLAP Database Designer for PostgreSQL 1.3.2 Build 750 (Feb 7, 2011)

  • Error logging improved
  • OpenSSL 1.0c used
  • Inherited constraints excluded by reverse engineering if not redeclared locally in childs
  • Reverse Engineering progress indication improved
  • "Cast error occurs in New Database Wizard if Connection Limit is higher then 0" bug fixed
  • "Reverse Engineering failed if table has dropped columns and constraints built on columnts at the end of the table" bug fixed
  • "Trigger time loaded incorrectly from file" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.3.1 Build 737 (Dec 16, 2010)

  • Inherit From" list sorted alphabetically in Table Editor
  • Double click on the found items in Find Objects now centers object in the draw area
  • Repair Model improved for stored routines
  • Stored procedure body indentations now saved "as is" in generated SQL
  • "Cannot add new roles to model sometimes" bug fixed
  • "EAccessViolation if Database Connection Manager's profile list empty" bug fixed
  • "FillFactor value set to 0 if model file from previous versions loaded" bug fixed
  • "Find Objects failed if Table is selected as Search object type" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.3.0 Build 724 (Dec 9, 2010)

  • Modify Database has the same options as the Database Generation now
  • Support for conditional trigger execution (WHEN) added
  • Support for exclusion (EXCLUDE) constraints added
  • Support for SQL-compliant per-column triggers added
  • Table's Storage Parameters support included
  • Deferrable unique constraints support added
  • Large object identifiers (>2147483647) support improved a lot
  • "Columns Default Values" option added to generation and modify options
  • "Reverse Engineering: INDEX TALESPACE information is fetched now for constraints"
  • "Reverse Engineering: storage parameters are fetched now for constraints and indices"
  • Support for FASTUPDATE storage parameter of GIN index added
  • Support for TRUNCATE triggers added
  • Additional checks added in object identifiers handling
  • Constraint's detail pane of Table Editor is invisible now if there is no constraints in the list
  • Extended error dialog displayed in case of Reverse SQL error
  • Fillfactor and WithOIDs options moved to Storage tab in Table Editor
  • Generate & Modify Dialogs preserve position and size after close
  • Most recently used colors are placed at the top of color lists on object editors' Format tab
  • New created indices in the Table Editor are not unique by default from now
  • Trigger tab in Table Editor refactored
  • "Access violation during disconnecting from database" bug fixed
  • "Access violation during SQL reverse engineering of some ALTER TABLE statements" bug fixed
  • "Cannot delete all sequences from model" bug fixed
  • "Corrupted default value for boolean fields in Column Manager are shown" bug fixed
  • "EInvalidCast error occurs if Default or Check info edited in Domains Type Manager" bug fixed
  • "Model file is corrupted if error occurred during saving" bug fixed
  • "No error messages shown for SQL Script Reverse Engineering" bug fixed
  • "Object identifiers are down cased after SQL Reverse Engineering" bug fixed
  • "Some hints are missing on buttons" bug fixed

New in MicroOLAP Database Designer for PostgreSQL 1.2.1 (Jun 16, 2007)

  • Smart reference counter added to avoid name duplicates
  • Ability to choose default folder for model files added
  • SQL Reverse Engineering for CREATE statements added
  • "Open last edited files at startup" feature added
  • Backup/autosave interval
  • "Leave current tool" options added
  • "Quick hand tool" feature added
  • Ability to select references or tables connected to selected tables
  • Enhanced reference visualization for selected tables added
  • Problems with references numeration
  • Bug with object search by partial string
  • Scale Combobox didn't update after Actual Size (F5) is executed
  • Disallow modification of columns and constraints referenced by Foreign Constraints

New in MicroOLAP Database Designer for PostgreSQL 1.1.2 (Sep 20, 2006)

  • MATCH type for references added, support of PostgreSQL 8.1.4 SQL grammar in internal Executor and Validator, added "Show Trigger" into display preferences.

New in MicroOLAP Database Designer for PostgreSQL 1.1.0 (Jul 10, 2006)

  • Color Palette added;
  • Rules support for Views and Tables added;
  • Reverse Enginnering adopted for latest PostgreSQL server changes.