Skip site navigation (1) Skip section navigation (2)

SQL Manager for PostgreSQL v. 4.2 released

Posted on Dec. 27, 2007

EMS Database Management Solutions are pleased to announce the new minor version of SQL Manager for PostgreSQL. You can download the newest version from the download page at http://www.sqlmanager.net/products/postgresql/manager/download.

What's new in SQL Manager for PostgreSQL 4.2?

  1. SQL Editor:

  2. the editor now works considerably faster; such features as syntax highlight, object hyperlinks are not disabled while processing large scripts;

  3. added the possibility to refresh DB Explorer automatically after successful execution of DDL statements;

the option is available in the Tools | SQL Editor section of the Environment Options dialog;

  • the Fit Column Width command is now automatically enabled for query results;

when exporting results of queries with parameters, the values of the parameters were not considered, and the result datasets were empty. Now fixed;

  • an error occurred upon exporting results of queries containing cast operators (::). Now fixed;

when using keyboard layouts of some East-European languages, certain symbols were not inputted. Now fixed;

  • INSERT, UPDATE, DELETE statements with the RETURNING clause (on PostgreSQL 8.2) did not return any result. Now fixed;

  • in some cases the object schemas were not considered in object hyperlinks. Now fixed.

2.DB Explorer:

  • added the Search Panel for quick search within the tree;

  • Window list is now available in the DB Explorer area, the corresponding tab has been added;

  • aliases for the databases that are accessed via SSH and HTTP tunneling are placed into separate server nodes with the corresponding icons;

  • when working in the 'Group functions by names' mode, on creating and deleting functions the changes were displayed incorrectly in the tree. Now fixed.

  • Support for Enterprise DB 8.2 is added.

  • Added the Find Option tool which allows one to find the required option in the scope of all program settings, by a word or an expression from the option title.

  • Visual Database Designer:

  • NOT NULL fields are now highlighted bold;

  • SERIAL and BIGSERIAL fields are now underlined.

  • View Editor: added a command for editing queries in Query Builder.

  • Function Editor:

  • when working with PostgreSQL 8.2, upon adding the OUT parameter an incorrect script of changing metadata was generated. Now fixed;

-when working with PostgreSQL 8.2, an error occurred upon execution of a function that returns RECORD. Fixed now;

-an error occurred upon compilation of a function containing OIDVECTOR[] as the OUT parameter. Now fixed;

-the Input parameters window is now resizable.

  1. Data grid:

  2. if a CIRCLE field contained a record with certain values, the “Error while posting updates” message appeared on attempt to save changes in data. Now fixed;

  3. if the standard_conforming_strings option was set on the server, an error occurred on editing data that required string escaping. Now fixed.

9.Table Editor, Fields tab: the base type is displayed in brackets for fields of domain type.

  1. Fixed an error that occurred on connection to PostgreSQL 8.3 beta.

  2. Download File wizard: an error occurred when working with PostgreSQL 8.2. Fixed.

  3. Query Builder: fixed several errors concerned with inability to parse the query code.

  4. Cascade/Tile functions now work only for non-minimized windows.

  5. Grant Manager: filter by object name worked only in case of complete match. Now fixed.

  6. SQL Manager 2007 Direct: the date of the latest update was not saved, therefore the form appeared each time when running the application.

  7. Other minor improvements and bug-fixes.

We hope you'll enjoy working with EMS products!

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


Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group