EMS SQL Manager for PostgreSQL

• Print this Page

02/18/2010

EMS SQL Manager for PostgreSQL version 4.7 released

We are pleased to announce the new minor version of SQL Manager for PostgreSQL - a high performance tool for PostgreSQL database administration and development. You can download the newest version from the download page.

What's new in SQL Manager for PostgreSQL 4.7?

1. Support of column level privileges is added (for PostgreSQL 8.4).
2. Grant Manager and Permissions tab of the Object Editor. The support of the Truncate privilege is added (for PostgreSQL 8.4).
3. SQL editors.
   • Added the possibility to use code folding for regions – parts that are limited by -- region and --endregion.
   • The file encoding selected in the Open/Save file dialog is saved and then used when opening/saving files next time.
   • The Undo command didn’t work for cancellation of the current line commenting (Ctrl+/).
4. Server Status. The Refresh Rate is now saved between working sessions.
5. Table Editor, Data tab.
   • The ‘Include Data of Descendant Tables’ option is added to the toolbar for tables which have descendants.
   • If a table contained a field with the name written in the upper case, an error occurred when sorting by that field. Fixed now. 
   • Non-English names of fields were displayed incorrectly. Fixed now.
   • When connecting through HTTP and on inserting data into a table with the serial field, an error occurred if the search_path for the given user had schemes which were absent in a database (for the mode with disabled transactions). Fixed now.
   • The ‘Set Empty String’ context menu item was always disabled for VARCHAR fields with unlimited size. Fixed now.
6. Aggregate Editor. Now it is possible to select domain as an input data type when creating aggregates (PostgreSQL 8.2 and higher).
7. Extract Database.
   • If the path to the script file contains folders which do not exist, they are created automatically.
   • Sometimes the wrong script was generated when extracting a function with the parameter from a different scheme than the scheme where the function is from.
8. SQL Editor. 
   • The Ctrl+D shortcut is added for the ‘Show Results on Edit Tab’ command.
   • With the certain options combination set, all queries resulted in “0 records fetched”. Fixed now.
9. The Input types in the aggregate DDL are now arranged in a column.
10. Key mapping. The confirmation dialog is now displayed on deleting a scheme and key combinations.
11. Create Table form. The default value for the ‘With oids’ option is now ‘off’, as the same default value is set on the server itself starting from version 8.1.
12. When registering the first database and then unregistering a host or a database, an Access Violation error occurred. Fixed now.
13. Visual Database Designer. If the object list was arranged in a tree, the double click on a scheme resulted in an Access Violation error. Fixed now.
14. Object Editors, Dependencies tab. If a non-English localization was set in the program, switching to the tab resulted in the ‘Floating point division by zero’ error.
15. Fixed some errors occurred when working with the row and record types in the Function Debugger.
16. If a storage parameter other than fillfactor was set for a table, an error occurred on connecting to a database. Fixed now.
17. Query Builder. 
    • Non-English names of fields were displayed incorrectly. Fixed now.
    • If a table or a field name was written in the lower case while in the query the same name was written in the upper case and was not quoted, an error occurred. Fixed now.
18. Function Editor. After executing a function which returned a record set, the Ctrl+Ins and Shift+Ins shortcuts stopped working in the function body editor. Fixed now.
19. Other small improvements and bugfixes.

We hope you’ll enjoy working with our software.