We are pleased to announce new version of SQL Manager 2005 for PostgreSQL. You can download the newest version from the download page.
What's new in SQL Manager 2005 for PostgreSQL version 3.7?
Database Registration. The option that allows to skip refreshing objects on connection to database is added. It is highly recommended to uncheck this option if your database contains many objects or if connection to the database is slow.
French localization added.
When editing a view a script of the DROP VIEW... CREATE VIEW type used to be generated which caused an error if there were objects dependent on that view. Fixed now.
Editor Options | Quick code. The option specifying whether the table field names should be sorted in Code Completion window is added.
Function Debugger. Now works properly with the functions containing variables like table.column%TYPE.
Grid.
"Word wrap in memo editor" option added (Environment Options | Grid | Advanced).
Formats set in Grid | Color & Formats were not applied to detail levels. Fixed now.
Table Editor | Data tab. It was impossible to edit or delete table records containing fields of TSearch2 type. Fixed now.
SQL Script. SQL Script window now remains open after disconnecting from the database.
When opening the data of a table with the primary key containing expressions an error used to occur and the data were not displayed. Fixed now.
Index and View Editors. When creating a view or an index their description was not saved. Fixed now.
DB Explorer.
After adding an object into the project it did not appear at the project tab. Fixed now.
After refreshing the tree the functions whose owner was removed were not displayed. Fixed now.
It was impossible to open a report or index via the Recent Objects menu. Fixed now.
The “Expand after connection” options were only applied to languages and tablespaces. Fixed now.
Field Editor. When changing object type from SERIAL to BIGSERIAL a wrong script used to be generated without taking the existing sequence into account. Fixed now.
The Reset all toolbars and menus option used to work incorrectly in some rare cases. Fixed now.
Some options in the Replace Text dialog of SQL Editor window used to work incorrectly. Fixed now.
Several bugs have been fixed that caused incorrect work of the program running on a system with dual display mode enabled.
Dependency Tree. The 'Save as image' button is now available at the navigation bar.
Now it's possible to resize To-Do Item Editor window.
Enabling/disabling the “Dollar-quoted function body” option could be applied only after program restart. Fixed now.
A large number of other small improvements and bugfixes.
This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.