EMS SQL Manager 2005 for PostgreSQL ver. 3.4 released - Mailing list pgsql-announce

EMS Company is pleased to announce SQL Manager 2005 for PostgreSQL ver.
3.4 -- the new version of the high performance tool for PostgreSQL Database
Server administration and development!

You can download the latest version of SQL Manager 2005 for PostgreSQL at:
http://www.sqlmanager.net/products/postgresql/manager/download

You can purchase SQL Manager 2005 for PostgreSQL at:
http://www.sqlmanager.net/products/postgresql/manager/buy


What's new in SQL Manager 2005 for PostgreSQL version 3.4?

1. SQL Editor. Query execution plan is now displayed as a graphical chart.

2. Full roles support on server 8.1.

3. Server Status service implemented.

4. SQL Formatter. Formats SELECT, INSERT, UPDATE, DELETE queries. (Available
from SQL Editor context menu).

5. Italian localization added (Luigi Covato).

6. SQL Script.

    - Now the process of script executing is shown and there is an
opportunity to stop this process.
    - Now you can open several windows at once.
    - When option 'Enable parsing' was enabled, editing a large script (> 10
M) caused hanging. Fixed now.

7. Grid.

    - Now when pasting records from the clipboard, you can set
correspondences between clipboard columns and query columns.
    - Form view. Memo fields editor is extended (can be customized in Grid >
Advanced tab of Environment Options dialog).
    - Blob View. 'Word Wrap' option is added for text.
    - 'Set to Empty String' and other similar operations do not result in
posting records in the table any more.
    - Works correctly with OID fields that have no BLOB object for their
values.
    - 'OID columns as BLOB' option added (except for fields with the name
oid)

8. Sequences can now be renamed.

9. Grant Manager.

    - Permissions for groups are now displayed on server 8.1.
    - When switching databases the 'Record index is out of bounds' error
occurred sometimes. Fixed now.

10. Report Designer and Report Editor. Support HTTP connection to database.

11. Query Builder. Saves queries between sessions.

12. SQL Editor. Now there are no limitations for the size of edited scripts.

13. Database Registration information. The feature Font Charset was not
saved. Fixed now.

14. When there were any connected databases, the process of switching
between program languages took a long time. Fixed now.

15. The needed documentation page did not open for some forms when pressing
F1. Fixed now.

16. If a user who connected to the database did not have rights for all
schemas, sometimes errors were emerged. The bugs are fixed.

17. DB Explorer.

    - After deleting the index or trigger, it was not deleted from the tree.
    - Data Manipulation. Did not work correctly for View function.

The bugs are fixed.

18. In some cases Query Builder hanged when parsing queries containing cast
operator "::". Fixed now.

19. When deleting a table opened on Data tab, the program hanged or the
operation was aborted by timeout. Fixed now.

20. SQL Editor border draws in accordance with the current visual scheme.

21. Function debugger. The operation of getting array element according to
its index resulted in an error when working with server 7.2.

22. Table Editor. Double click on the index in Table Explorer did not open
its editor. Fixed now.

23. After renaming the object its name in the DB Explorer context menu was
not updated. Fixed now.

24. Other improvements and bugfixes.


What is SQL Manager 2005 for PostgreSQL?

EMS SQL Manager for PostgreSQL is a powerful graphical tool for PostgreSQL
Database Server administration and development. SQL Manager for PostgreSQL
works with any PostgreSQL versions up to 8.0 and supports all of the latest
PostgreSQL features including tablespaces, argument names in functions, and
so on. It offers plenty of powerful tools for experienced users such as
Visual Database Designer, Visual Query Builder, and powerful BLOB editor to
satisfy all their needs. SQL Manager for PostgreSQL has a new
state-of-the-art graphical user interface with well-described wizard system,
so clear in use that even a newbie will not be confused with it.

We hope you'll enjoy our products.

Thanks for your attention.
EMS Software Development, LLC.