Database Designer for PostgreSQL 1.2.4 released

Version 1.2.4 (June 20, 2008)

Critical bug with references mismatch after Save is solved. Repair Model functionality added which is intended to restore reference integrity. Enumerated types support added. SQL parser and validator are 8.3.x compatible. Several minor bugs are fixed.

You're welcome to download the latest release from our website at:
http://microolap.com/products/database/postgresql-designer/download/

Full changelog:

[!] Support for enumerated data types added

[+] "Backup DB tables before modify" option added to Modify Dialog

[+] "Show object icons" option added to Display Preferences

[+] COST option support for Stored Routines added

[+] Export supports splitting into pages now

[+] FILLFACTOR storage parameter added for index

[+] IF EXISTS clause option for DROP statements added in Database Generation

[+] Progress indication and interrupt ability added for Export functionality

[+] Repair Model functionality added

[+] ROWS option support for Stored Routines added

[+] Table, stored routine, view comments; rules and triggers information added to report generation

[*] SQL Executor parser (validator) is PostgreSQL 8.3.x grammar compatible now

[-] "Access Violation when Check Diagram" bug fixed

[-] "Can't declare SECURITY INVOKER permissions for stored routine" bug fixed

[-] "Comments are missing in Stored Routine editor Preview tab" bug fixed

[-] "Duplicate function in Table Editor creates objects (columns, indexes, constraints) with equal unique identifier" bug fixed

[-] "Reference label color loaded incorrectly from model file" bug fixed

[-] "Relation mismatch after Save" bug fixed

[-] "String started with more then two dashes not treated as correct SQL comment" bug fixed

[-] "Table columns may get incorrect IDs during Reverse Engineering" bug fixed

[-] "Trailing semicolon (;) missed in domain comment statement" bug fixed

[-] "Trailing semicolon (;) missed in user type comment statement" bug fixed

[-] "Validate function of SQL Executor returns wrong result sometimes" bug fixed