MicroOLAP Database Designer with PostgreSQL 9.2 support is out!
Posted on 2012-09-27 by Microolap
In this release we focused on changes in the 9.2 version of the PostgreSQL server
Support for new JSON, SMALLSERIAL and range types introduced.
Internal SQL parser improved a lot and is fully compatible with PostgreSQL SQL dialect.
Collation support for tables introduced as well.
LEAKPROOF stored routine specification is supported from now, as well as security_barrier option added for views.
And of course all known bugs are fixed.
Download
You're welcome to download the Database Designer for PostgreSQL 1.8.4 right now at: http://microolap.com/products/database/postgresql-designer/download/
Feedback
Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at
http://www.microolap.com/support/
Full changelog:
- [!] Color Palette customization ability added
- [!] User Type and Domain selection tab added to reverse Engineering dialog
- [+] COLLATION support for table columns added
- [+] COMMENT clauses now proccessed by SQL Reverse Engineering
- [+] JSON type support added
- [+] Support for built-in range types added (INT4RANGE, INT8RANGE, NUMRANGE etc.)
- [+] LEAKPROOF function specification added
- [+] security_barrier option added for views
- [+] SMALLSERIAL data type added
- [*] "Import from SQL Script" dialog allows to edit script if error occured
- [-] "SQL Reverse Engineering cannot import function with argument of anyelement type" bug fixed
- [-] "SQL Reverse Engineering cannot import function with name Op" bug fixed
- [-] Random "List index out of bounds" error fixed during Reverse Engineering of enum types
- [-] "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