EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS News & Events

All News & Events

10/06/2014
EMS SQL Manager for PostgreSQL version 5.5 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 Manager for PostgreSQL 5.5?

  1. Added support of new PostgreSQL 9.4 features:
    - Support of JSONB data type
    - Support of changing foreign key deferability parameters without recreating the key
    - Support of moving all objects from one tablespace to another
  2. Extract Database. Now the result script is correctly organized according to objects dependencies.
  3. Backup Database. Now it is possible to add the current date and time to the result dump file name.
  4. Change Management. Added support of the Slik Subversion 1.8.x client (SQL Manager works with 32-bit client version only).
  5. SQL Editor. Code Completion. The PostgreSQL keywords is updated considering the last server versions.
  6. Table Editor. Reorder Fields. Now the trigger is created after the data insert in the change script.
  7. SQL Editor. Now if the ‘Don’t save queries automatically for the next session’ option is enabled, the user is warned that the changes are not saved automatically on closing the SQL Editor tab.
  8. Change Management. SVN.
    - If the HTTPS-certificate is not valid the user is requested on performing the operation whether to ignore the validation mistake or abort the operation.
    - On entering non-latin characters in a commit comment to the Version Control System the “Cannot write database history record” error appeared. Fixed now.
  9. SQL Editor. Query Plan. Now the numerical values are right-aligned and are splitted by orders.
  10. DB Explorer. Now the Search field is not emptied when the search is finished.
  11. Backup Database. The long operation log was cut at the end. Fixed now.
  12. Function DDL. Illegal characters for unquoted identifiers were quoted incorrectly in parameters names. Fixed now.
  13. Data Export. When exporting to the DBF file values of integer fields appeared in the result file with a thousand separator. Fixed now.
  14. The wrong script generated on renaming fields of a view in a non-default schema. Fixed now.
  15. Sometimes error occurred on changing a field type to smallserial. Fixed now.
  16. Function Debugger. It was impossible to change the variable value of the time type.
  17. Large number of other improvements and bug fixes.

twitterfacebook