PostgreSQL 8.2 management extensions.
Now it is possible to specify fill factor when creating/editing tables and indexes.
Support of CONNECT privilege for databases and USAGE privilege for sequences is added. For setting sequence-specific permissions the GRANT ON SEQUENCE syntax is used instead of GRANT ON TABLE one.
Now it is possible to empty a table together with all foreign-key referencing tables.
Now it is possible to create a domain based on another one.
Added support for comments on server-scope objects such as roles and tablespaces.
Other server management extensions:
The Make primary key and Clear primary key commands are now accessible anywhere in the software (Table Editor, Explorer Tree, Object Browser, etc).
Since this version PostgreSQL Maestro can display native type names such as int4 instead of SQL-standard ones (e.g. integer).
SQL Formatter is done: you can beatify all the DML statements (SELECT, INSERT and UPDATE) in the SQL Editor. Also it is possible to format view definitions.
The tabbed interface is implemented in addition to classic MDI. You can choose your favorite UI in the Options dialog.
SQL Script Editor: if a user opens a file larger than 100K, PostgreSQL Maestro will suggest him to execute the script file without opening it in the editor. Of course it is also possible to execute any script file using
this way: just press the "Execute script from file" link on the Script Editor navigation bar and specify the filename.
Full press-release is available at:
Product home page:
This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.