EMS logo

Products Navigation

choose your database tool

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS News & Events

Main News

EMS SQL Manager for PostgreSQL version 5.4 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.4?

  1. Added support of new PostgreSQL 9.3 features:
    - Support of materialized views.
    - Support of recursive views.
    - Support of event triggers.
  2. SQL Editor. Code Completion improvements:
    - The list of columns of function and subquery aliases is shown now.
    - The list of table / subquery columns of current SELECT query is now shown at Code Completion even without indicating its alias.
    - Context sensitive elements: aliases of the current SQL query, local variables, table / subquery columns now are arranged at Code Completion at the top of the list.
  3. Function Debugger. When the debugger is launched for the first time, the same parameter values are set as the ones for function execution.
  4. Such types as event_trigger and json are added to the list of standard types.
  5. Table, View Editors. Rename command is now available for subobjects.
  6. Operator Editor. Name field now allows entering admissible characters for operator name only.
  7. Several errors are fixed in Function Debugger:
    - If the last string of the function body was a comment, syntax error occurred. Fixed now.
    - If the function to debug contained operations with oid-type values, "can't read the blob" error occurred. Fixed now.
    - If a too large number was set as a bigint-type parameter, its precision was lost. Fixed now.
  8. The main menu command Help | PostgreSQL Reference worked incorrectly. Fixed now.
  9. Function Editor.
    - In some cases copy/paste data from the clipboard shortcuts Ctrl+Ins and Shift+Ins stopped working. Fixed now.
    - At times when exporting results of the function returning rowset, access violation error occurred. Fixed now.
  10. Find/Replace dialogs. Keyboard accelerators of some input fields were duplicated. Fixed now.
  11. Data Export wizard. When using Skip records option, it indicated that export had been carried out with errors, while in fact the operation had been successful. Fixed now.
  12. Lots of other improvements and bug-fixes.

We hope you’ll enjoy working with our software!