EMS SQL Manager for PostgreSQL version 4.3 released

We are pleased to announce the new minor version of EMS SQL Manager for PostgreSQL (http://www.sqlmanager.net/products/postgresql/manager).

You can download the newest version from the download page ().

What's new in SQL Manager for PostgreSQL 4.3?

1. Support of new PostgreSQL 8.3 features:

2. support of ENUM data types

3. support of TSVECTOR, TSQUERY, XML and UUID types;

4. support of arrays of composite types;

5. support of index key sorting order (ASC, DESC; NULLS FIRST, NULLS LAST);

6. support of new PostgreSQL 8.3 statistic data (Database Statistics tool).

7. Support of operator classes in index keys.

8. DB Explorer. Composite types are now displayed as a separate node within the database objects tree.

9. SQL Editor.

Unicode was not supported upon inputting parameters for queries containing parameters' declaration. Fixed now.

When working with several instances of SQL Editor, Favorite queries were not always saved correctly. Fixed now.

1. SQL Editor, SQL Script Editor.

A number of functions now work faster.

For some statements code folding worked incorrectly; also, in DDL functions code folding is now used to collapse the entire function body.

The code completion list for table aliases was not opened if used at the end of the query. Fixed now.

The first word of the statement is now displayed in the collapsed code parts.

Keyboard templates do not trigger in comments any more.

The default schemas from the search_path configuration parameter are considered when applying the code completion and object links highlight.

1. Import Data Wizard.

The client encoding was not considered, therefore the 'Invalid byte sequence for encoding...' error occurred in some cases. Fixed now.

The 'Commit changes manually' option did not work. Fixed now.

1. Data grid.

Sub-levels based on a SQL query can now be edited in the Load All Rows mode as well, if the query is built by one table and contains key fields.

Upon insertion of text into a grid cell, pressing Shift-Ins resulted in duplicating field dialog. Fixed now.

Depending on the program settings, if a column name contained the dot (.) character, it was impossible to edit table data. Fixed.

1. Other minor improvements and bug-fixes.

We hope you’ll enjoy working with our software.

Full news text:

http://www.sqlmanager.net/products/postgresql/manager/news/1326

This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.