Online Documentation for SQL Manager for PostgreSQL

Version history

 

 

Version 6.5.1

 

1. Improved processing of local variables in procedures and SQL editor.

2. The list of arguments with default values is displayed correctly now.

3. Table view activates display all rows mode if all data is loaded.

4. GEOMETRY data is displayed as BLOB now.

5. Hint size is correct for non-standard scaling.

6. Timeout value increased for SSH connection.

7. GENERATED columns are processed right on column order change.

8. Version control updated for procedures and statistics.

9. Improvements in dark visual scheme.

10. Many other improvements and fixes.

 

Version 6.5

 

1. SQL Manager x64 for PostgreSQL released.

2. Service templates are now saved in UTF8.

3. New authentication methods added.

4. Support of STATISTICS objects added.

5. NULLS NOT DISTINCT option added to indicies editor.

6. SET COMPRESSION option added for table columns.

7. Improvements in Service Status viewer.

8. TIMESTAMP and TIMESTAMPTZ data can be optionally displayed as string.

9. Multiple rows of tabs is now supported in Query Data.

10. Multiple Cursor datasets are now displayed correctly in Function results.

11. PDF data can be viewed from BLOB editor now.

12. Many other improvements and fixes.

 

Version 6.4.3

 

1. The issue when opening Export Data Wizard has been resolved.

2. The Owner was not displayed for Aggregates. Fixed now.

3. Types from pgcatalog could not be selected for state type aggregates. Fixed now.

4. The error occured in Enum types editor on editing values. Fixed now.

5. The "Control 'Preview' has no parent window" error resolved in Print data editor for data grid.

6. Details of the operations were not displayed on clicking the elements in Query Plan. Fixed now.

7. In some cases the error occured when executing queries with parameters. Fixed now.

8. Other minor fixes and improvements.

 

Version 6.4.2

 

1. Improvements in PostgreSQL 15 support.

2. Improved support of dark schema for interface.

3. Support for LANGUAGE SQL body for functions.

4. FK links can be optionally hidden in Design Query editor now.

5. Templates for backup and restore are now saved in Unicode format.

6. Improved performance in Server Log Viewer.

7. Export of images as SQL Script now works correctly.

8. Filter window for data grid is resizable now.

9. Resizing of Database Designer editor works better now.

10. The list of visible columns was reset on switching to Card view. Fixed now.

11. Other improvements and fixes.

 

Version 6.4.1

 

1. Support for PostgreSQL 15 added.

2. Fixed issue with client sorting of NUMERIC data.

3. Sequence values are added correctly for GENERATED BY DEFAULT columns.

4. 'Automatically open last diagram file' option didn't work in Database designer. Fixed now.

5. Improvements in code highlighting in SQL editors done.

6. The charset errors in BLOB editor fixed.

7. Other improvements and bugfixes.

 

Version 6.4

 

1. Added displaying of field types in Data tab.

2. Support for index storage options implemented.

3. Improvements in server log viewer implemented.

4. DB explorer objects can be collapsed and expanded at once now.

5. Indices for views added to Version control.

6. Support for Ed25519 Putty private keys implemented.

7. Support for Windows 11 ARM implemented.

8. Filters implemented for ENUM data type.

9. Better processing of large NUMERIC data in Data editor.

10. Next\Previous search is now more precious in the DB tree.

11. Performance improved for HTTP tunnelling.

12. Better formatting of JSON data.

13. Hot keys added for use of markers in script editor.

14. Fixes of displaying procedure privileges done.

15. Processing of milliseconds for TIMESTAMP data improved.

16. Table fields added to autocompletion for INSERT INTO operator.

17. The error occurred on adding data with autogenerated values. Fixed now.

18. The error occurred on editing comments for materialized views. Fixed now.

19. Code highlighting improved in script editor.

20. The error fixed in Procedure debugger on using search_path with specific symbols.

21. Toolbars reset didn't work in some cases. Fixed now.

22. Favorite queries are now saved when using Save settings wizard.

23. DB Comparer. Sequences are now extracted without OWNER.

24. Many other improvements and fixes.

 

Version 6.3.2

 

1. Show OWNER on DDL tab option added.

2. Sorting implemented for text BLOB fields.

3. Hosts an databases are sorted by name in drop-down menus.

4. Data type added to the field name in the code completion list.

5. Data format settings are now available for export into XLSX file.

6. Quotation mark was duplicated on export in some cases. Fixed now.

7. Commands in one line are now executed properly.

8. Log tab is activated on error only now.

9. The error of displaying Bit varying data fixed.

10. Unnecessary quotation marks added to parameter history in procedures. Fixed now.

11. SSL settings are now saved correctly for databases.

12. Issue with using Space in passwords resolved.

13. Many other fixes and improvements.

 

Version 6.3.1

 

1. The GENERATED option added on fields creating.

2. Fields are formatted more accurately in INSERT INTO statements.

3. Minor errors fixed in parameters history of functions.

4. The Out of range error on the Dependencies tab is fixed.

5. Minor improvements in displaying dark color schema.

6. Other fixes and improvements.

 

Version 6.3

 

1. Parameters history is now loaded correctly on changing SQL text.

2. Databases are now focused on launching the program.

3. The list of events has been updated for EVENT TRIGGER.

4. The error occurred in the debugger with many parameters used. Fixed now.

5. TIMESTAMPTZ data was imported incorrectly in some cases. Fixed now.

6. Decimal numbers are now rounded correctly.

7. Filtering is not truncated on switching between table tabs now.

8. New Query data button is added to the toolbar.

9. The error occurred on using aliases in Query Designer. Fixed now.

10. Other minor improvements and fixes.

 

Version 6.2

 

1. The libraries for connection via SSH have been updated.

2. Valid processing of extensions added for PostgreSQL 13.

3. No more freezing occurs on adding a new user in the User manager.

4. The INCLUDE parameter is now displayed correctly for indices.

5. The error occured on running queries with aggregate functions. Fixed now.

6. Databases in the Save settings wizard are now sorted by name.

7. You can switch to an already opened Query editor with F12 now.

8. Print Data preview was generated on opening the Data tab. Fixed now.

9. The file is now opened instead of just copying its content into Script Editor.

10. Other improvements and bug-fixes.

 

Version 6.1.1

 

1. Improved work with Amazon RedShift.

2. COPY command is now supported in script editor.

3. Quick access to Search in Metadata from object tree added.

4. NULL values were not assigned correctly in the debugger. Fixed now.

5. Search path command was not applied for query plan. Fixed now.

6. Path to the last opened file is now saved in script editor.

7. Work with TIMESTAMPTZ data type improved.

8. The warning appears if the file is changed outside of the script editor.

9. The error of moving extension to another scheme fixed.

10. Host aliases are now displayed correctly in object editors.

11. Current values for sequences were truncated on reordering table fields in some cases. Fixed now.

12. Other fixes and improvements.

     Version 6.1

 

1. Multiple Query data editors are now allowed for the same database.

2. Multiple Search in metadata windows can be opened now.

3. Improvements in find and replace text dialog.

4. Imporved performance of Debug with extension.

5. Extension functions and procedures are no longer displayed in DB Explorer, if system objects are disabled.

6. Fix of defining BOOLEAN parameters in the debugger.

7. Microseconds are always displayed for timestamptz data type now.

8. Many other fixes and improvements.

 

Version 6.0.1

 

1. Font for autocompletion list is changed with editor font now.

2. Data refresh in materialized views with transactions enabled is performed without Timeout error now.

3. Fixes in Find text and Search in metadata.

4. Disappearing of the main menu in localized interface fixed.

5. Close all windows action now requires confirmation.

6. Toolbars on the main form can be moved without any restrictions now.

7. Editor content is saved correctly on renaming server alias.

8. Other minor fixes and improvements.

 

Version 6.0

 

1. Support of dark visual scheme added.

2. The new look with updated icons.

3. Added support for PostgreSQL 12.0.

4. Support of Unicode added for object names.

5. Improved support of high-DPI monitors and large-scale fonts.

6. Editor tabs can be now highlighted with color specified for the database.

7. Support for server aliases implemented.

8. JSON tab added for viewing data.

9. Description support added for tablespaces.

10. "Refresh concurrently" command added for materialized views.

11. Trailing spaces are not automatically trimmed for CHAR fields now.

12. Fixes and improvements of auto completion feature in query editor.

13. Custom formatting can now be applied to timestamptz data.

14. Many other bug-fixes.

15. Other improvements of interface and usability.

 

Version 5.9.5

 

1. Procedures are now supported.

2. Added support for 11.1 version backup.

3. PARALLEL option added to functions.

4. Storage method is now displayed for fields.

5. Improved syntax check in functions.

6. Type name was not displayed for some user data types in functions. Fixed now.

7. Minor fixes in the Save settings wizard.

8. Nested multiline comments are now recognized correctly.

9. Query plan didn’t return any data if no space was set after EXPLAIN. Fixed now.

10. Transaction was sometimes aborted on importing data if database and client charset was different. Fixed now.

11. Statements for OWNER change in materialized view were generated incorrectly. Fixed now.

12. BIT VARYING data with unlimited size is now displayed correctly in data frame.

13. Many other fixes and improvements.

 

Version 5.9.4

 

1. Support for backup and restore of 10.4 и 11.0 server versions has been added.

2. Compare databases. Support for partitioned tables implemented.

3. Compare databases. NEXT_VALUE is not synchronized for sequences by default.

4. Owner info is now displayed on the DDL tab.

5. REFERENCING option is now supported in triggers.

6. Some errors in the debugger have been fixed.

7. Minor improvements in Query Data highlighting.

8. Many other improvements and bug-fixes.

 

 

 Version 5.9.3

 

1. Added GENERATED AS IDENTITY property for fields.

2. Import failed in "Update or Insert" mode, if all columns were selected as keys. Fixed now.

4. Fixes and improvements in the Debugger.

5. User list is now exported to the correct folder.

6. Privilegies are restored correctly on recreating the field now.

7. Support of partition options has been implmented in the Extract database wizard.

8. Cast operator (::) can be used with parameter symbol (:) correctly.

9. Text with quotes and backslashes is imported correctly now.

10. Functions with domain-based parameters were not displayed in Search metadata results. Fixed now.

11. Export of TO-DO list has been implemented.

12. Trailing spaces were trimmed on copying records in the grid. Fixed now.

13. Many other improvements and bugfixes.

 

 Version 5.9.2

 

1. Support for PostgreSQL 10 has been added.

2. Added support for partitioned tables.

3. The Debugger has been considerably improved.

4. Debugging with pldbgapi extension is possible now.

5. Improvements in Compare databases wizard.

6. Function editor windows with long names are restored correctly now.

7. In some cases passwords from pgpass.conf were not used. Fixed now.

8. Commit and Rollback buttons are not shown now if no changes were made.

9. Query Data. Execution of the query will continue on error, if "Show result for each query" is enabled.

10. Form view. NOT NULL attribute was not available for BOOLEAN type. Fixed now.

11. Function editor. The shortcut for debugging changed to Ctrl+D now.

12. Many other fixes and improvements.

 

    Version 5.9.1

 

1. New options added in the Policy Editor.

2. Support of WITH RECURSIVE syntax in the Debugger added.

3. The error occurred on debugging procedures with the same name for input parameters and table field. Fixed now.

4. Unicode symbols were not imported correctly in Batch insert mode. Fixed now.

5. Commit transaction button was not displayed in some cases. Fixed now.

6. The comments are saved correctly now in Database Designer.

7. Comments for indices are now duplicated correctly to a new schema.

8. Many other bugfixes and improvements.

 

        Version 5.9

 

1. Support for SSL certificates implemented.

2. Support for constraint triggers added.

3. Working with data in grid is performed with Savepoints now.

4. Search path can be set in the debugger now.

5. The hang of the program on editing scripts has been eliminated.

6. Text tab is opened by default for text types in BLOB editor now.

7. Raise notices used to display at the end of the execution in Query Data. Fixed now.

8. Script for indices was not generated on materialized view modification. Fixed now.

9. Hot keys added for search results in DB Explorer.

10. Many other improvements and bugfixes.

 

        Version 5.8.1

 

1. Fix of backup error on 9.6 version of PostgreSQL.
2. There was an error on exporting some query results. Fixed now.
3. The result dataset of the query was not editable if the comments preceded the query text. Fixed now.
4. NUMERIC values were incorrectly exported into SQL. Fixed now.
5. SSH connection was not established in some cases with OpenSSH private key used. Fixed now.
6. Lots of other improvements and bugfixes.

 

          Version 5.8

 

1. Support for PostgreSQL 9.6 has been added.
2. Support for DEFERRABLE/NOT DEFERRABLE and INITIALLY DEFERRED/INITIALLY IMMEDIATE options for Primary and Unique keys.
3. Support of PHP 7.x in HTTP-tunneling module.
4. Function debugger. Extended support for RAISE and EXCEPTION statements; processing of replace directives added.
5. Some errors of Formatter have been fixed.
6. Toolbar settings are saved correctly now.
7. INTERVAL dimension was displayed incorrectly. Fixed now.
8. Memory errors in Grant Manager have been fixed.
9. Export of Unicode data from BLOB fields has been fixed.
10. Lots of other improvements and bugfixes.

 

 

          Version 5.7.1

 

1. Added support of the latest versions of OpenSSH.
2. Authentication error occurred when SSH private key was used. Fixed now.
3. The 'Access Violation' error occurred when on index creation localization was turned on. Fixed now.
4. The default directories were set incorrectly when a new host was registered. Fixed now.
5. Other improvements and bug-fixes.

 

 

        Version 5.7.0

 

1. PostgreSQL 9.5 support.
2. Support of 'REPLICATION' groups option.
3. Support of 'BRIN' method for table indexes.
4. The ability to change the 'LOGGED' table option added.
5. Support of inheritance for external tables.
6. Support of table policies.
7. Indexes for materialized views have been implemented.
8. The errors on managing objects containing quotes in their names have been fixed.
9. Some memory errors have been fixed.
10. Other improvements and bug-fixes.

 

 

        Version 5.6.2

 

1. Work with memory has been improved.
2. The error on closing BLOB Editor has been fixed.
3. Opening of SQL Script from the command line is performed in the same program instance now.
4. Autocomplete for big functions and SQL queries has been improved.
5. Use of triggers for more than 64 fields is possible now.
6. The errors occured in Group Manager if there was no "Can create roles" permission set. Fixed now.
7. Export Data. Export format is saved for the next session now.
8. The connection error messages have been improved.
9. Some objects with quotes were incorrectly processes in Function Editor. Fixed now.
10. Export Data. Default tab name has been changed for export to MS Excel
11. Export Data. Export formats are renamed to comply with MS Office standards.
12. Lots of other improvements and bug-fixes.

 

 Version 5.6.1

 

1. Processing of REFCURSOR values at the Data tab has been improved.
2. Now managing groups is possible for non-Admin users having the appropriate permissions.
3. Improved handling of the functions having "_" character in the name.
4. The order of objects generated by Extract Database tool was incorrect. Fixed now.
5. There were some issues starting the application on specific national Windows versions. Fixed now.
6. Several memory issues have been fixed.
7. Fixes for Excel and CSV formats in Import Data wizard.
8. The errors on opening Server Status tool have been fixed.
9. Descriptions were lost on changing field order. Fixed now.
10. Script fot duplicating UNLOGGED tables was generated incorrectly. Fixed now.
11. Lots of other bug-fixes.

 

 

 Version 5.6.0

 

1. Support of foreign data wrappers, foreign servers and foreign tables is added.
2. Dependency Tree.

• Added the possibility to move the tree within the display area by holding the left mouse button.
• Changed the drawing of selected object and recursive objects for better distinction.
• Added different display modes of dependency tree: to show all objects, to show objects depending on selected object, or only objects selected object depends on.
• Selected object is placed to the display area automatically now when the dependency tree is too large.

3. Table Editor. Data tab. The possibility to create automatically the detail data levels for tables connected with the given one by means of foreign keys is added.
4. Windows panel.

• Added the ability to move tabs of open windows with a mouse.
• Now it is possible to close the windows with the scroll button.

5. DB Explorer. Favorite queries and scripts can be added into 'Favorite Objects' folders.
6. Environment Options.

• The possibility to set the Parameter character for SQL queries (Tools tab).
• It is possible to set the font for data grid separately.
• DB Explorer. Added the 'Start-with search' option for searching objects.
• DB Explorer. Added the 'Auto expand navigation pane' option.
• Added the possibility to switch off the 'Restore desktop on connection' option for the databases having the 'Refresh objects on connection' option off.
• Added the possibility to specify which database should be selected for a newly opened editor or tool: the database selected in DB Explorer or the one from the currently focused editor.
• Design Query | Color Palette options. Added the possibility to set colors for active and inactive table caption text (the 'Windows style of tables' should be turned off).
• Global Shortcuts. Added shortcuts for the debugger.

7. Query Data. Now after executing the 'BEGIN' SQL-statement the 'Commit' and 'Rollback' buttons become available in the toolbar and the navigation bar, even if using transactions is not turned on in the 'Database Registration Info' dialog. Also the confirmation of transaction ending will appear on closing the form (if it is not disabled on the 'Confirmations' tab of the 'Environment Options' dialog).
8. Data Grid. Now it has become possible to select several cells and copy them to clipboard. To do this it is necessary to switch on the 'Cell selection' and 'Row/cell multi-selection' options on Grid tab of the Environment Options dialog.
9. Duplicate Object wizard. Now when duplicating a table to another database the data copy statements are not added to the main table script, but are executed separately. This requires less memory.
10. SQL editor.

• Quick Code. It is possible to choose item in the Code Completion list with the 'Space' or with the 'TAB' key (optional).
• The possibility to select the query text and choose the 'Export Data' dialog with the help of corresponding context menu item.

11. Export Data as SQL Script, Extract Database. Now the last chosen charset is selected in the 'Script destination' | 'File charset' field by default.
12. Query Data. Query Plan.

• Now the query execution plan can be displayed graphically if the 'Verbose' option is used.
• The 'Operation info' is implemented as a separated text field now.

13. Visual Options. Added the possibility to set Slants Kind property value for page controls.
14. Some forms were sized incorrectly when the 'Medium' size was chosen for the 'Control Panel\Display | Size of All Items' Windows option. Fixed now.
15. SQL Monitor. Now the log can be executed as usual SQL-script: all the additional information is formatted as SQL-comments.
16. Lots of other improvements and bug-fixes.

 

 

 Version 5.5.0

 

1. Added support of new PostgreSQL 9.4 features:
2. • 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. Query Data. 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. Query Data. 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 Query Data 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. Query Data. 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.

 

 

 Version 5.4.0.1

 

1. Added support of new PostgreSQL 9.3 features:

• Support of materialized views.
• Support of recursive views.
• Support of event triggers.

2. Query Data. 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.

 

 Version 5.3.0.1

 

1. Now when modifying an object, a window is marked with an asterisk (*) in the window title. The same is for the files opened in SQL Script form, Database Designer diagrams, etc.
2. Database Registration Info dialog. Added the possibility to set PostgreSQL parameter values ​​for a session.
3. Grant Manager. Added the possibility to extract grants as SQL script.
4. Function Editor.

• In case a function is modified, when calling the debugger, the program asks to compile this function, debug it without compiling and debug the older version of the function.
• In some cases the syntax checking worked incorrectly. Fixed now.
• After being compiled the cursor changed its position in the function body. Fixed now.

5. Query Data.

• Now the cursor data can be opened for the refcursor results (if running within a transaction).
• 'Union' was highlighted as alias, if it was placed next to the FROM section. Fixed now.
• When executing a query with nested comments, an error occurred. Fixed now.

6. Restore Database wizard. Now it correctly works with very large SQL files.
7. DB Explorer.

• When opening the enum type a new form opened, even if the other editor of this type was already opened. Fixed now.
• If the "Sort by Aliases" mode is on and "Show arguments as child nodes" is set for displaying the function, the function arguments were sorted in alphabetical order that led into error. Fixed now.

8. Extract Database wizard.

• When using PostgreSQL 9.1 and higher a query was executed to the pg_authid system table, and if having no permissions it caused an error. Fixed now.
• When extracting composite types for array fields the number of array dimensions was not taken into account. Fixed now.

9. Editor Options. The background color settings were applied to object description fields, but foreground color settings were not. Fixed now.
10. Database Designer. If there were no printers set in the system, opening the form caused the "There is no default printer currently selected" error. Fixed now.
11. View Editor. After a trigger was modified, the information on the Triggers tab was not updated. Fixed now.
12. Search in Metadata. Searches are not performed in temporary objects now.
13. In the Floating windows environment mode the Windows Taskbar appeared upon launching the program, even it was hidden in the previous session. Fixed now.
14. Create Report wizard. The selected report style could not be applied to the report. Fixed now.
15. Dependency Tree. The dependence between parent and inherited tables could not be shown in the subobject display mode.
16. New Table form. When pressing Ctrl + Insert the Add filed dialog popped up, even if there was another active tab. Fixed now.
17. Many other improvements and bugfixes.

 

 

 Version 5.2.0.1

 

1. Added support of new PostgreSQL 9.2 features:

• Support of range types
• Support of SMALLSERIAL data type
• Support of privileges on data types
• Support of not validated и non-inheritable check constraints
• Support for renaming constraints
• Support of the SP-GiST Index access method
• Support of the security_barrier option for views

2. Database Designer.

• Now views and functions can be added to a diagram
• Added the possibility to display attribute properties (optionality, keys, etc.) in parentheses after the attribute name and type.
• Diagram print options are now saved in the diagram file.
• Added the possibility to display diagram print margins.
• Added the possibility to drag and drop schemes on the diagram.
• When loading a diagram from the file the connection line position was not restored. Fixed now.
• After loading a diagram and switching between diagram pages a value in the zoom field was not updated. Fixed now.

3. Function Editor.

• Added the possibility to check SQL syntax in the function body. Also the "Check syntax after compilation" option is added.
• Added support of function configuration parameters.
• When formatting a function body using Quick Code | Format, extra spaces appeared in the declarations of %rowtype and %type variables that caused a compilation error. Fixed now.

4. Backup Database wizard.

• Added the possibility to connect to a server through an SSH-tunnel.
• Sometimes in databases with large tables an error saying that pg_dump process did not answer occurred, though the execution itself continued as normal. Fixed now.

5. Restore Database wizard.

• Added the possibility to connect to a server through an SSH-tunnel.
• Added a progress bar when restoring data from an SQL file.
• When restoring COPY commands with large datasets from SQL files, the "Out of memory» error occurred. Fixed now.

6. Export/Import Data.

• Now in most cases the exported data is not re-requested.
• Some errors occurring during export/import operations are fixed now.

7. Query Datas.

• Code Completion now allows you to select variable fields of composite and % rowtype types in the PL/pgSQL function body.
• "Save file as" dialog. The last selected value of the "Don’t add 'Byte-order-mark' to Unicode files" option is now saved between sessions just as Charset.

8. Function Debugger.

• Added support of the RAISE EXCEPTION 'message' USING ERRCODE = 'XXXXX' statement.
• Added support of USING expression in the OPEN CURSOR command.
• Added support of Unicode strings.

9. Change Management. Added support of VisualSVN Server.

10. Query Data. Now the query execution time is displayed more accurately with no additional cost for the program.

11. Foreign Key Editor. Added support of foreign keys without validation (PostgreSQL 9.1 and higher).

12. Server status. Added the "Application name" column to the Connections list.

13. Data Frame.

• When inserting data from a clipboard, geometry field data with uppercase characters in the field name could not be inserted. Fixed now.
• When executing the "Set the value of | Set to the empty string" command, an extra space instead of an empty string was inserted for large varchar fields. Fixed now.
• Filtering ​​GUID values caused an error. Fixed now.
• Editing XML fields on PostgreSQL version 9.0 and higher in some cases caused an error. Fixed now.
• Blob View tab was not available for XML fields, if the data did not contain Blob fields of different types. Fixed now.

14. Database Explorer.

• Database Tree. Now there are pseudo- and not defined types displayed in the Base Types branch.
• Object name hints not fitting to width could not be displayed. Fixed now.

15. Object Editor. Permissions tab. The "Grant All" option no longer assigns permissions to owner.

16. Extract Metadata. DROP statements were not written for Enum types. Fixed now.

17. Extensions. The program hung after installing PostGIS extensions. Fixed now.

18. SQL Script. When executing the COPY command with large dataset from an SQL file, the "Out of memory" error occurred.

19. HTML Report. In some cases national characters in object names were displayed incorrectly in the generated report. Fixed now.

20. SQL Monitor. EventTime was displayed improperly. Fixed now.
21. Save Settings Wizard. The settings of SQL Formatter, Global Shortcuts and Object Templates could not be saved. Fixed now.
22. Many other improvements and bugfixes.

 

 

 Version 5.1.0.1

 

1. Added support of new PostgreSQL 9.1 features:
2. • Support of collations.
   • Support of extensions (the Database Extensions tool in the Services main menu).
   • Support of view triggers.
   • Support of ALTER composite and ENUM types
   • Support of unlogged tables.
2. Backup Database wizard. Added the support of creation of backup copies for PostgreSQL 9.1.
3. Added the support of the column list for UPDATE triggers (PostgreSQL 9.0 and higher).
4. Function debugger. Added the possibility to debug trigger functions.
5. Function Editor.
6. • Added the Ctrl+H shortcut to hide/display function header controls.
   • Added the possibility to quickly specify the returned void and trigger types.
   • Now in the form header for functions with multiple parameters, the parameter list is truncated to fit the information about the database and server as well.
   • Now in the Tools | Object Editors section of the Environment Options dialogue, it is possible to set the default values for the “Execute with definer's privileges” property for CREATE functions.
   • The Ref Cursor type is transferred to the standard type section in the selection list of the returned values now.
   • The context menu items in the return table fields list were always disabled. Fixed now.
   • When performing any function in the editor, if setting some large absolute values ​​for BIGINT, a value was passed into the function incorrectly. Fixed now.
   • When closing the function editor with a large number of parameters, the “Failed to create key XXX” error occurred.  Fixed now.
   • Variables with the “< table field name >%type” were not reflected in the code completion list. Fixed now.
6. Trigger Editor. Added the Ctrl+H shortcut to hide/display the trigger caption controls.
7. Change Management. Added the support of Slik Subversion client. Also the support of CollabNet Subversion client for Subversion.
8. Added the possibility to export table data into the file in many tools.
9. Check Constraint Editor. Added the possibility to set comments for constraints.
10. Foreign Key Editor. Now the form size can be changed.
11. To-Do Item Editor. When opening a form, the focus is set on the input text field now. Added the shortcut keys for switching to all input fields.
12. Data Grid.
13. • If while closing the form with the data grid, the record was only changed, but not posted, the program now asks to save/reset changes in the record.
    • The size of the numeric datatype fields with precision 15 or more was determined incorrectly - it was not allowed to enter large values. Fixed now.
13. Query Data.
14. • If with the disabled “Show the result for each query” option, there was a statement separator (;) next to a comment after the SELECT query text, the result was empty. Fixed now.
    • The Ctrl+N shortcut of adding a new query tab did not work. Fixed now.
    • When using the Azeri (Latin) locale some characters displayed incorrectly. Fixed now.
    • With the enabled “Allow using parameters in the query text” option the rows with a colon in the comments were also considered as query parameters, and while executing the query the input dialogue of values appeared. Fixed now.
14. Database Designer.
15. • After deleting a table from the diagram, saving and restarting the diagram, the deleted table appeared again. Fixed now.
    • In the “Floating windows environment” mode in some cases the diagram field became inactive, it did not respond to mouse clicks and did not allow adding a table. Fixed now.
15. Design Query.
16. • Queries, having a statement in the parsing join condition, gave an error. Fixed now.  
    • In the “Floating windows environment” mode after having moved the courser over some tabs, they were drawn incorrectly. Fixed now.
16. Function debugger.
17. • When debugging functions with separate CASE statements, an error occurred. Fixed now.
    • If outer and inner code blocks had variables with the same name, the displayed value of the variable was not changed during being transferred into the inner block. Fixed now.
    • In some cases when debugging functions that use the BIGINT variables, the "Overflow while converting variant of type (int64) into type (integer)" error occurred. Fixed now.
17. Server Status.
18. • Even being disconnected from the server, the timer information continued to be updated, and each time an error occurred. Fixed now.
    • If after being disconnected, the server became available again, the connection was not restored even if pressing the “Refresh” button – the form had to be reopened. Fixed now.
18. View Editor. The Dependency tab. In some cases not all dependencies were shown.  Fixed now.
19. Extract Database. In server version 8.2 and higher, in some cases the CREATE SEQUENCE statement followed the CREATE TABLE statement. Fixed now.
20. Export as SQL script. When creating a non-PostgreSQL script, the INSERT statements were generated with errors. Fixed now.
21. Create Table form. If the “Unique” option is specified for the filed, while saving the table this option did not reach the script and it was not saved. Fixed now.
22. User manager. If the “Change management” option is switched on for the first database of the host, and there are no any connected databases of this host, when creating a new role and while saving, an AV error occurred. Fixed now.
23. Restore Database wizard. When restoring an SQL file with the CONNECT statement, an error occurred. Fixed now.
24. Index Editor. When adding a new Index key from the context menu, the “Could not convert variant type (Null) into type (OleStr)” error occurred. Fixed now.
25. Grant Manager.
26. • Double-clicking on an empty field or on a grid header was interpreted as double-clicking on an active cell. Fixed now.
    • For the role, which name was a substring of another rolename, the cumulative rights of these two roles were shown. Fixed now.
26. Save Settings wizard. When saving keyboard templates to the file and restoring them on another PC, the templates with line brakes were not restored. Fixed now.
27. DB Explorer. When registering a database in one program copy, this database also appeared in the tree of another opened copy, however its Change management settings were empty. Fixed now.
28. Print Metadata. The page size in the template for tables A4 was incorrect. Fixed now.
29. SQL Script. The type and object names of some SQL statements were determined incorrectly for being displayed in the Statements explorer.
30. Vacuum Tables and Analyze Tables wizards. Even when selecting separate tables, the action was performed on all tables in the database. Fixed now.
31. Other small improvements and bugfixes.

 

 

 Version 5.0.0.1

 

1. The Change Management tool is added. It helps to organize the control of the database development process: allows to rollback the database to the certain time, work with different database branches, view the history of changes, etc. It is integrated into the following version control systems: CVS, Subversion, Visual SourceSafe, TFS.
2. Added the Database Comparer tool which allows getting a script to synchronize the database structure.
3. The Search in Metadata tool is implemented for performing the quick search within the scope of database metadata. The tool allows you to set various search conditions and view the results.
4. Database Designer.
5. • Added the 'Undo' and 'Redo' operations
   • Now it is possible to select schemas for reverse engineering.
   • Added tools for formatting diagram objects: setting fonts, colors, etc.
5. HTML Report. Now it is possible to define the report visual style.
6. Added the Database Registration Manager which allows adding and deleting database registrations quickly.
7. Added the Instance Manager service which allows checking the service status of PostgreSQL server and staring/stopping the service.
8. Added the possibility to define shortcuts not only for Query Data commands, but for some other commands too (Environment Options | Global Shortcuts).
9. Object names in DDL are not quoted now if it is not necessary.
10. SQL Formatter now allows formatting DDL statements.
11. The switching between windows is now performed with the Ctrl + Tab shortcut.
12. Added the possibility to duplicate objects in other databases by drag-and-dropping them in DB Explorer.
13. Many other small improvements and bugfixes.

 

 

 Version 4.8.0.1

 

1. Added support of new PostgreSQL 8.4 features.

• Support of exclusion constrains.
• Support of the ‘when’ clause for triggers.
• Support of new versions of pg_dump/pg_restore in the Backup Database and Restore Database wizards.
• Added the ‘Explain buffers usage’ option for the query execution plan.
• Fixed an error occurred after creating a trigger that had function arguments.

2. Function Editor. Now when pressing the Tab button in the parameters table, the focus is moved to the next table cell.
3. Function Editor. When launching a function, it was not possible to enter the time value manually for the timestamp type in the dialog of entering parameters. Fixed now.
4. DB Explorer. If the display of system objects is enabled, the table's row types are displayed in the Composite Types branch.
5. Table Editor. The commands of creating/editing/deleting rules did not work on the navigation bar of the DB Explorer. Fixed now.
6. When an SSH connection was lost, it was possible to restore it only after the program restart. Fixed now.
7. Function Debugger. It was not possible to set a value with more than 10 digits for the numeric parameter type. Fixed now.
8. In SQL editors and grid it was not possible to enter some national characters using the keyboard. Fixed now.
9. Database Statistics. The value of the All objects/User objects/System objects field was ignored after refreshing: all objects were displayed. Fixed now.
10. Design Query. Queries containing conditions based on the true/false were parsed incorrectly. Fixed now.
11. Other small improvements and bugfixes.

 

 

 

 Version 4.7.0.1

 

• Support of column level privileges is added (for PostgreSQL 8.4).
• Grant Manager and Permissions tab of the Object Editor. The support of the Truncate privilege is added (for PostgreSQL 8.4).
• SQL editors.

Added the possibility to use code folding for regions – parts that are limited by -- region and --endregion.

The file encoding selected in the Open/Save file dialog is saved and then used when opening/saving files next time.

The Undo command didn’t work for cancellation of the current line commenting (Ctrl+/).

• Server Status. The Refresh Rate is now saved between working sessions.
• Table Editor, Data tab.

The ‘Include Data of Descendant Tables’ option is added to the toolbar for tables which have descendants.

If a table contained a field with the name written in the upper case, an error occurred when sorting by that field. Fixed now.

Non-English names of fields were displayed incorrectly. Fixed now.

When connecting through HTTP and on inserting data into a table with the serial field, an error occurred if the search_path for the given user had schemes which were absent in a database (for the mode with disabled transactions). Fixed now.

The ‘Set Empty String’ context menu item was always disabled for VARCHAR fields with unlimited size. Fixed now.

• Aggregate Editor. Now it is possible to select domain as an input data type when creating aggregates (PostgreSQL 8.2 and higher).

• Extract Database.

If the path to the script file contains folders which do not exist, they are created automatically.

Sometimes the wrong script was generated when extracting a function with the parameter from a different scheme than the scheme where the function is from.

• Query Data.

The Ctrl+D shortcut is added for the ‘Show Results on Edit Tab’ command.

With the certain options combination set, all queries resulted in “0 records fetched”. Fixed now.

• The Input types in the aggregate DDL are now arranged in a column.
• Key mapping. The confirmation dialog is now displayed on deleting a scheme and key combinations.
• Create Table form. The default value for the ‘With oids’ option is now ‘off’, as the same default value is set on the server itself starting from version 8.1.
• When registering the first database and then unregistering a host or a database, an Access Violation error occurred. Fixed now.
• Database Designer. If the object list was arranged in a tree, the double click on a scheme resulted in an Access Violation error. Fixed now.
• Object Editors, Dependencies tab. If a non-English localization was set in the program, switching to the tab resulted in the ‘Floating point division by zero’ error.
• Fixed some errors occurred when working with the row and record types in the Function Debugger.
• If a storage parameter other than fillfactor was set for a table, an error occurred on connecting to a database. Fixed now.
• Design Query.

Non-English names of fields were displayed incorrectly. Fixed now.

If a table or a field name was written in the lower case while in the query the same name was written in the upper case and was not quoted, an error occurred. Fixed now.

• Function Editor. After executing a function which returned a record set, the Ctrl+Ins and Shift+Ins shortcuts stopped working in the function body editor. Fixed now.
• Other minor improvements and bug-fixes.

 

 

 

 

 Version 4.6.0.1

 

• Added support of new PostgreSQL 8.4 features:

Variadic functions; functions returning table; function argument default values

ON TRUNCATE triggers

SELECT queries containing WITH clause

pg_dump/pg_restore options (options were added to the Backup Database and Restore Database wizards)

start value in sequence

• Query Data:

Using macro is now possible in Query Data and SQL Script

Highlighting of the corresponding brackets is added

Fixed several bugs concerning the incorrect parsing of table aliases in queries

The line with an error was not highlighted correctly even if the error message contained the correct information. Fixed now

Query interruption is now performed via libpg.dll instead of the pg_cancel_backend function. It is not necessary to be a superuser to interrupt your own query

If a file name and location were too long for the window title, the program used to cut the filename. Now it cuts the file location

When a query returned the Infinity value to a timestamp filed, the program used to display this value as Null. Fixed now

• Data View:

When viewing table data, BLOB data are now loaded from server only after it is addressed to

The support of the Infinity, -Infinity and NaN values is added for ‘real’ and ‘double precision’ fields

The 'Perform data sorting on client' and 'Perform data filtration on client' options were removed. The program now selects the optimal mode automatically

A syntax error sometimes occurred on inserting huge data to a bytea field. Fixed now

• Function Debugger:

The RETURN QUERY and RETURNING … INTO … statements are now supported

An error occurred on fetching data from ‘for execute’ cursor. Fixed now

A syntax error used to occur if a function contained FOR … IN EXECUTE … LOOP statement. Fixed now

• Extract Database:

Non-user objects used to be loaded when extracting a whole database. Fixed now

The Add OID into object comments option is added

The speed of the data extraction increased

The constraints’ description was extracted as COMMENT ON INDEX that resulted in an error. Fixed now

• Function Editor:

Cursor data returning by a function can now be exported

The ‘List index out of bounds’ error occurred when editing some functions’ body. Fixed now

When compiling a function returning data of the composite type, the utility generated the wrong script. Fixed now

• Functions’ DDL:

Arguments are ordered in a column now

The Parameter name was not quoted even if it was a key word. Fixed now

The “char” (pg_catalog.char) parameter was displayed as CHAR. Fixed now

• Changing Metadata:

The 'Recompile with Double Timeout' and 'Recompile with Unlimited Timeout' buttons now appear if the script execution was stopped due to timeout limit exceeding

Monospaced font is used for error messages containing code fragment and error position pointer

• Grant Manager: when granting privileges to a table with a SERIAL field, the utility suggests granting rights to the corresponding sequence
• SQL Script: if a file name and location were too long for the window title, the program used to cut the filename. Now it cuts the file location
• Export as SQL Script: when a table definition was formed during the export to PostgreSQL, field types used to be defined incorrectly. Fixed now
• DB Explorer: the 'Restart Sequence' command is added to the Task submenu of the context menu
• Data Export: when exporting data of the decimal type with the precision more than 14 digits, the numbers were rounded to the 4th decimal digit. Fixed now
• Table Editor: the Refresh command didn’t work at the Description tab. Fixed now
• The wrong script was generated when NOT NULL fields were added to a table containing default values. Fixed now
• View Editor: sometimes the query text was formatted improperly. Fixed now
• Print Metadata: the long function title used to hide the part of the function text in the report. Fixed now
• Visual DB Designer: if a field that links tables was dropped and diagram containing these tables was opened, the “List index out of bounds” error used to occur. Fixed now
• SQL Monitor, Backup/Restore wizards: non-English messages weren’t converted from UTF-8 to Unicode. Fixed now
• Fixed some errors that occurred when working in the 'Floating windows environment' mode

 

 

 Version 4.5.0.1

 

 

• Database Registration Info dialog:

most of the options from the Grid | Data Options section of the Environment Options dialog can now be specified individually for each of the registered databases in the Database Registration Info dialog. The values specified on the Grid | Data Options page will be applied as default settings for newly registered databases

the 'Schema-organized database tree' option is added. With this option disabled, the object tree is built without grouping by schemas

metadata and Query Data logs can now be saved in UNICODE or ANSI

• Design Query:

when a table is added into a query, its foreign key connections to other tables participating in this query are reflected by JOIN statements

in some cases renaming a table and moving to the SQL tab resulted in the “Cannot bind JOIN expression” error. Fixed now

• Function Editor:

the results of functions returning cursor can now be viewed

if the DOUBLE PRECISION argument value was set to “0”, the function execution led to the substitution of this value with “NULL”. Fixed now

• The Unicode support is implemented in function bodies, views, rules, check constraints, object description, field default values, domains and in a number of object properties
• DB Explorer:

many PostgreSQL add-in objects are considered to be system objects and aren’t displayed in the DB Explorer tree if the Show system objects option is disabled for the database

the Find Object dialog has been improved

the button for switching search mode is added to the Search Panel toolbar

the possibility to reorder hosts using drag-and-drop is implemented

the program saves the information about the last opened database before shutdown. When the application is started next time, this database will be automatically selected in the DB Explorer tree

double-clicking an object group node folds and unfolds it

• Database Designer:

tables are arranged more compactly in the reverse engineering mode

alignment options did not work when a diagram was opened from the file

Some printers could not print field and table icons. Fixed now

• Data View | Blob View: added the XML tab allowing you to view XML data as a tree
• Data Grid: The method of work in the asynchronous mode is changed – the usage of a separate connection for each Data Grid makes it possible to perform simultaneous fetching without losing the ability to use other functions of the program
• Extract Database, Export as SQL Script: Now the script is directly generated in the selected charset which reduces the script generation time
• Options: The ability to apply default settings (to all or just a separate category of options) is implemented for all option dialogs
• View Editor, Rule Editor: when editing a view or rule, the SQL query is formatted with SQL Formatter. DDL of views no more contains extra brackets in expressions
• Now a role can be set as an object owner (available for PostgreSQL version 8.1 and higher)
• Windows List: Close All Database Windows command is implemented
• Foreign Key Editor: Now there is a possibility to view or edit foreign key description
• The Serial fields as integer option value is now taken into account not only in table DDL, but also in all cases when the field type is displayed
• New option was added to the Object Editors tab of the Environment Options dialog. It allows you to define whether to split function options into several lines in DDL or to display all options in one line
• Table Editor: Export Data, Import Data and Export as SQL Script wizards can be now accessed from the editor toolbar even if the data tab is not active
• Save Settings wizard: Now when saving settings to the existing file, the program suggests that you overwrite the file or make the new file unique by adding the current date and time to the file name
• Check Constraint Editor: Now the size of the editor window can be changed; it is also saved for future sessions
• Data Grid: The mouse cursor color changes if the grid is not active
• Query Data: Creation of queries with identical names was allowed. Fixed now
• Code Parameters:

code parameters were not sometimes displayed for the second and further function arguments. Fixed now

if several functions were created with the same names but different arguments, code parameters were shown only for one of these functions. Fixed now

if the automatic display of code parameters was disabled, it was impossible to access parameters even with the Ctrl+Shift+Space shortcut. Fixed now

• user-defined array types used to be displayed improperly in DDL. Fixed now
• Query Data:

several errors concerning SQL code highlighting were fixed

when saving data to a file using any charset different from Unicode, further opening of the save dialog would set the charset to Unicode

• If an error occurred on saving an object while using HTTP tunneling, it was not displayed at the Changing Metadata window. This made it possible to commit changes, though no changes were really made
• Relations of composite and table types with other objects were not displayed in the Dependency Tree and at the Dependencies tab. Fixed now
• When editing or deleting a record containing polygon and/or point field, an error sometimes occurred. Fixed now
• Function Debugger: a syntax error occurred on opening function with a FOR … IN construction. Fixed now
• Numeric fields of high precision used to be edited and displayed incorrectly in the data grid. Fixed now
• SERIAL fields’ sequences values were not restored after reordering of columns. Fixed now
• Editing money fields resulted in an error if PostgreSQL server parameters were set in a specific way. Fixed now
• Database Properties: an error occurred on saving a database whose description contained the back slash ('\') character.  Fixed now
• Other minor improvements and bug-fixes

 

 

 Version 4.4.0.1

 

• Implemented Backup Database and Restore Database Wizards allowing one to perform backup/restore operations with the help of pg_dump and pg_restore utilities of PostgreSQL server
• Aggregate Editor: added support of aggregate functions with multiple arguments; added support of sort operator for MIN- or MAX-like aggregates
• Function Editor: added support of planner options for PostgreSQL server version 8.3
• Function Editor: added the Ctrl+Up/Ctrl+Down shortcuts for changing the argument order
• Function Editor: after recreation of a function, grants on the function were not restored. Fixed now
• Data grid: support of the PostGIS geometry type; it is possible to view and edit geometry columns in Table Editor; in Query Data columns based on asEWKT, asText function calls are editable
• Data grid: the 'Use key and changed fields' option is added for searching for records on update/delete (available in the Grid | Data Options section of the Environment Options dialog)
• Data grid: numeric values of high precision are correctly displayed and edited now
• Function Debugger: added the 'Run to cursor' command
• Function Debugger: in case of a syntax error the number of the line containing the error is returned
• Function Debugger: fixed several errors concerning function execution and added support of some new PL/pgSQL constructions
• SQL Script: added support for the \connect <database_name> command for setting the current database during script execution
• SQL Script: the 'Default directory for scripts' option (available in the Setting default directories section of the Database Registration Info dialog) did not work. Fixed now
• SQL Script: added support of the CREATE RULE statement with the ALSO clause; the end of the statement used to be determined incorrectly
• After importing data into a table with Import Data Wizard used, and after insertion of records in the data editing mode, the current sequence value is updated for SERIAL and BIGSERIAL fields
• Tablespace Editor: tablespace size is displayed now
• HTML Report: added a possibility to change the font size for the DDL section (the corresponding option is added to the Setting additional report options step of the wizard)
• Index Editor: added the 'Mark as index to cluster table on' option
• A toolbar with tools from the 'Services' menu is added to the main form
• Added support of LATIN9 encoding for opening/saving SQL scripts
• Changing Metadata window: the size and position of the window are saved now
• It is now possible to insert a tab symbol in the 'Description' area (within the Description tab) of object editors
• Visual DB Designer: the NOT NULL flag was not displayed for fields based on NOT NULL domains. Fixed now
• Extract Database: in some cases function definitions were doubled in the extracted script. Fixed now
• Extract Database: tables created with option WITH OIDS enabled were extracted without this option. Fixed now
• The position and content of the main form toolbars were not saved. Fixed now
• The Code Parameters list did not popup for quoted object names. Fixed now
• Query Data: SQL sorting for grouping queries with ORDER BY clause did not work. Fixed now
• Other minor improvements and bug-fixes

 

 

 Version 4.3.0.1

 

• Support of new PostgreSQL 8.3 features: support of ENUM data types; support of TSVECTOR, TSQUERY, XML and UUID types; support of arrays of composite types; support of index key sorting order (ASC, DESC; NULLS FIRST, NULLS LAST); support of new PostgreSQL 8.3 statistic data (Database Statistics tool)
• Support of operator classes in index keys
• DB Explorer: composite types are now displayed as a separate node within the database objects tree
• Query Data: Unicode was not supported upon inputting parameters for queries containing parameters' declaration. Fixed now
• Query Data: when working with several instances of Query Data, Favorite queries were not always saved correctly. Fixed now
• SQL editors: a number of functions now work faster
• SQL editors: for some statements code folding worked incorrectly; also, in function DDL code folding is now used to collapse the entire function body
• SQL editors: the code completion list for table aliases was not opened if used at the end of the query. Fixed now
• SQL editors: the first word of the statement is displayed in collapsed code parts
• SQL editors: keyboard templates do not trigger in comments any more
• SQL editors: the default schemas from the search_path configuration parameter are considered upon filling the code completion list and object links highlight
• Import Data Wizard: the 'Client encoding' database parameter was ignored, therefore the 'Invalid byte sequence for encoding...' error occurred in some cases. Fixed now
• Import Data Wizard: the 'Commit changes manually' option did not work. Fixed now
• 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
• Data grid: upon insertion of text into a grid cell, Shift-Ins resulted in the duplicating field dialog. Fixed now
• Data grid: depending on the program settings, if a column name contained the dot (.) character, it was impossible to edit the table data. Fixed now
• When deleting an Index, the index name did not contain the schema name in the generated SQL statement. Fixed now
• Export Data Wizard: when exporting results of queries of certain type, the 'Parser: parse error at end of input' error used to occur. Fixed now
• SQL Manager wizards: the databases configured for connection via SSH and HTTP were not displayed in database drop-down lists. Fixed now
• When working with PostgreSQL 8.3, all triggers were displayed as disabled. Fixed now
• Visual Options: the 'Menus show recently used commands first' option selection was not saved upon closing the application. Fixed now
• Function Editor: added the Ctrl+Ins and Ctrl+Del shortcuts for adding and removing parameters respectively
• Create Database Wizard: at the Setting advanced database properties step only parameters that are applicable for the current server version are displayed now
• Keyboard Templates: when using the Paste command in a template body, applying the template resulted in insertion of the first word only, instead of the entire text from the clipboard. Fixed now
• Dependency Tree: if the tree building was interrupted, rebuilding was not initiated upon subsequent selection of an object. Fixed now
• Other minor improvements and bug-fixes

Scroll to top

 

 Version 4.2.0.1

 

• Query Data: the editor now works considerably faster; such features as syntax highlight, object hyperlinks are not disabled while processing large scripts
• Query Data: added the possibility to refresh DB Explorer automatically after successful execution of DDL statements; the option is available in the Tools | Query Data section of the Environment Options dialog
• Query Data: Fit Column Width command is now automatically enabled for query results
• Query Data: when exporting results of queries with parameters, the values of the parameters were not considered, and the result datasets were empty. Fixed now
• Query Data: an error occurred upon exporting results of queries containing cast operators (::). Fixed now
• Query Data: with keyboard layouts of some East-European languages used, certain symbols were not inputted. Fixed now
• Query Data: INSERT, UPDATE, DELETE statements with the RETURNING clause (on PostgreSQL 8.2) did not return any result. Fixed now
• Query Data: in some cases the object schemas were not considered in object hyperlinks. Fixed now
• DB Explorer: added the Search Panel for quick search within the tree
• DB Explorer: Window list is now available in the DB Explorer area, the corresponding tab has been added
• DB Explorer: aliases for the databases that are accessed via SSH and HTTP tunneling are placed into separate server nodes with the corresponding icons
• DB Explorer: when working in the 'Group functions by names' mode, on creating and deleting a function the changes were displayed incorrectly in the tree. Fixed now
• Added support for Enterprise DB 8.2
• 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
• Database Designer: NOT NULL fields are now highlighted bold
• Database Designer: SERIAL and BIGSERIAL fields are now underlined
• View Editor: added a command for editing a query in Design Query
• Function Editor: when working with PostgreSQL 8.2, upon adding the OUT parameter an incorrect changing metadata script was generated. Fixed now
• Function Editor: when working with PostgreSQL 8.2, an error occurred upon execution of a function that returns RECORD. Fixed now
• Function Editor: an error occurred upon compilation of a function containing OIDVECTOR[] as the OUT parameter. Fixed now
• Function Editor: the Input parameters window is now resizable
• Data grid: if a CIRCLE field contained a record with certain values, Error while posting updates occurred on attempt to save changes in data. Fixed now
• Data grid: if the standard_conforming_strings option was set on the server, an error occurred on editing data that required string escaping. Fixed now
• Table Editor, Fields tab: the base type is displayed in brackets for fields of domain type
• Fixed an error that occurred on connection to PostgreSQL 8.3 beta
• Download File wizard: an error occurred when working with PostgreSQL 8.2
• Design Query: fixed several errors concerned with inability to parse the query code
• Cascade/tile windows now works only for non-minimized windows
• Grant Manager: filter by object name worked only in case of complete match. Fixed now
• SQL Manager Direct: the date of the latest update was not saved, therefore the form appeared each time when running the application
• Other minor improvements and bug-fixes

Scroll to top

 

 Version 4.1.0.1

 

• Import Data Wizard: import using the COPY command is implemented. To activate this mode, set 'Batch insert' as import type at the Set import and data write type step
• Now the codepage can be set for a file when opening/saving it in SQL editors
• The spell checking feature is implemented in SQL editors to check and perform corrections to SQL code automatically. The spell checking parameters can be set on the Spell Checking page of the Editor Options dialog
• In many object lists the ability to perform incremental search appeared
• Blob Editor could not be used for text fields. Fixed now
• Russian localization is added
• Data Form View: for strings longer than 80 characters the editor for TEXT fields is opened. The 'Word wrap in string fields' option is added as well
• Data Grid: when inserting data into TEXT fields the data used to get truncated to 8 kb size. Fixed now
• Code completion: object names in uppercase are inserted in quotes now
• Code completion: the Code completion window did not open for the first word of the first line in the editor area. Fixed now
• Query Data: for the table with the name in lowercase in SELECT queries whenever the table name contained capital letters the results of the query turned to be read-only. Fixed now
• Query Data: when saving the tab content into a file, after moving tabs, the file turned out to be linked to a wrong tab. Fixed now
• Query Data: in some rare cases one was unable to interrupt query execution; also, with some specific options set, interrupting query execution raised an error and lead to disconnecting from the server. Fixed now
• Query Data: when several instances of Query Data are used and the content of one of them is being saved, the changes in the content of the other ones are also considered
• In table DDL the method of checking whether the field is of SERIAL type is improved. Now the field is considered to be of SERIAL type only when its sequence name corresponds to the table name and field name
• Export Data as SQL Script: When exporting data to a file the warning window is displayed if the file already exists
• DB Explorer: the Create Database and Drop Database items are added to the context menu
• DB Explorer: works faster with the databases containing many objects
• DB Explorer: the Favorite Queries node (when it was created) used to disappear after refreshing. Fixed now
• Server Configuration, Role Settings: on attempt to add a parameter the AV error occurred. Fixed now
• In some rare cases the AV error raised when disconnecting from a database. Fixed now
• HTML Report: at the Selecting object types step the buttons for selecting/excluding all objects are added
• Download File wizard: when returning to a previous step, the parameters entered were not saved. Fixed now
• Names of tables in lowercase were not highlighted as links in Query Data if typed in capital letters. Fixed now
• Table Editor: when creating a foreign key its sign was not refreshed within the Fields tab. Fixed now
• If in the Lite version of SQL Manager the limit of registered databases was exceeded, an empty-named database used to be added into the DB Explorer tree after reconnect. Fixed now
• After aligning windows, e.g. by title vertical, the window size and its position used to be lost if any other object was selected at the Object bar of the editor. Fixed now
• Other minor improvements and bug-fixes

Scroll to top

 

 Version 4.0.0.1

 

Basic features:

• Support of UTF8 data in Query Data, Design Query, Grid View, Data Export/Import Wizards
• Now you can continue working with SQL Manager while a query is being executed in Query Data or Design Query or while table or view data are being loaded in the editor. A query taking too long to execute can be aborted when using PostgreSQL 8.0 and higher
• New Database Statistics form added; it allows viewing various statistic information on database objects, helps to find weak points in database performance, indicates if it is necessary to create new indices, etc. The corresponding options must be enabled in server configuration file (postgresql.conf.) for collecting statistics
• All wizards, including Data Export/Import, DB Extract, Copy DB wizards can now be run in the background mode, so that you could continue working with the program
• New improved Query Data of the Visual Studio 2005 kind with the Code folding function and UNICODE support
• Improved Data Import Wizard now allows one to import data up to 10 times faster. New import formats have been added: HTML, XML Document, Open Document Format (OpenOffice), Open XML Format (MS Word 2007, MS Excel 2007)
• Support of new PostgreSQL 8.2 features is implemented: FILLFACTOR parameter for tables and indices; CONNECT permission for databases; USAGE permission for sequences; support of CREATE INDEX CONCURRENTLY; ALTER TABLE [ NO ] INHERIT support; creating domains based on other domains; support of the IF EXISTS clause in DROP operators of the Extract Database wizard; reassigning ownership of all objects owned by a role
• Object editors now contain the Permissions tab which allows to grant permissions on the object to users and groups
• Common SQL commands can now be generated from DB Explorer (Script to Query Data, Script to Clipboard). Now you can easily generate such SQL commands as CREATE, ALTER, DROP, SELECT etc for each database object
• Now you can save your queries within the Favorite Queries folder in DB Explorer; these queries can be stored either locally in the registry (nobody but you will have access to them) or in a special database table (then all or some of your db users will have access to it)
• Download File wizard has been added; it allows one to download and upload files from/to PostgreSQL server machine using standard PostgreSQL functions and FTP/SFTP protocols
• Improved Database Designer: new object type - comments - is added. One can now choose whether only object names or fields should be displayed. Now it is possible to select schemas whose tables should be added to the diagram when performing Reverse Engineering
• Improved Export Data Wizard now works faster. New export formats have been added: XML Document, Open Document Format (OpenOffice), Open XML Format (MS Word 2007, MS Excel 2007)
• The Database Properties window has been added, which displays database options and allows to change some of them
• Improved Table Editor: now it is possible to view and change table properties on a new tab
• The Tasks menu is added to the DB Explorer context menu. It contains common operations which can be performed on the object selected. Also hosts are now named in accordance with the selected connection type (SSH or HTTP tunneling)
• Improved the report building system
• Function Debugger: The variable that changed its value at the last step is displayed bold at the Debug Information window. The SQLSTATE and SQLERRM variables are also displayed now
• Lots of other improvements and bug-fixes

and more...

Scroll to top

 

 Version 3.8.0.1

 

• SQL Script: ability to execute selected statements and statement under cursor added
• SQL Script: ability to execute the statements like COPY FROM STDIN
• SQL Script: the notices returned by server when executing statements are now displayed at the message list
• SQL Script: the scheme set via the ‘SET search_path’ operator is now taken in consideration when forming the object name to be displayed  in the Explorer
• SQL Script: the error list was not cleared when loading a file
• Grant Manager: the ability to set the grants with grant option added
• Extract Database: now it is possible to extract data as a set of COPY statements
• Extract Database: as compared with the previous version of the tool, the extract process now takes less time
• Extract Database: the ‘Dollar-quoted function body’ option is now applied to the function definitions created by Extract Database wizard.
• SSH tunneling: support of authentication by key
• SSH tunneling: the ability to establish connection for several hosts/databases at the same time is added
• Function Debugger: dollar-quoted strings support implemented
• Function Debugger: SELECT INTO statements are now supported
• Function Debugger: Variables list: affected rows and result oid added
• Function Debugger: fixed a bug with incorrect work of a function containing variables like table_name.column_name%TYPE
• Function Debugger: when executing the ‘Continue’ operator the syntax error used to occur. Fixed now
• Function Debugger: the RAISE NOTICE command terminated function execution. Fixed now
• Data Grid: the filter applied for date type fields worked incorrectly if a date format type other then MDY was used in system settings. Fixed now
• Data Grid: on attempt to apply any filter with the SQL filter and ‘Select only *’ records limitation used the data were displayed incorrectly. Fixed now
• Data Grid: mouse-wheel scrolling for the Form View is implemented
• Dependency Tree: with the Show subobjects option enabled the dependencies were displayed not quite correctly. Fixed now
• Dependency Tree: objects icons were not printed
• Server Configuration, Parameter List tab: the 'Parameter Group' column added which allows to display the parameters in groups
• Visual Options: the 'Menus show recently used commands first' option added
• Editor Options: the ability to set the default colors added
• Environment Options, DB Explorer section: the 'Refresh object on showing in SQL Assistant' option is added
• DB Explorer: a newly created object was not listed in the 'Recent Objects' drop-down menu
• Import Data Wizard: when importing from DBF format, the default values for the boolean type were False and True (instead of required F and T), so it was necessary to change them for the proper ones while processing the data. Fixed now
• Environment Options, Windows section: the ‘Number of open editors is restricted’ option didn’t work. Fixed now
• Environment Options, Preferences section: the 'Save desktop on disconnect' option did not apply to rules, indices, triggers and reports
• Log Viewer: on attempt to open a local PostgreSQL server log the IO error 32 error raised and the current log did not open. Fixed now
• Other small improvements and bug-fixes

Scroll to top

 

 Version 3.7.0.1

 

• Database Registration: the option that allows one to skip refreshing objects on connection to database is added. It is highly recommended to uncheck this option if your database contains many objects or if connection to the database is slow
• French localization added
• When editing a view, a script of the DROP VIEW... CREATE VIEW type used to be generated which caused an error if there were objects dependent on that view. Fixed now
• Editor Options | Quick code: the option specifying whether the table field names should be sorted in Code Completion window is added
• Function Debugger: Now works properly with the functions containing variables like table.column%TYPE
• Data Grid: "Word wrap in memo editor" option added (Environment Options | Grid | Advanced)
• Data Grid: formats set in Grid | Color & Formats were not applied to detail levels. Fixed now
• Table Editor, Data tab: it was impossible to edit or delete table records containing fields of TSearch2 type. Fixed now
• SQL Script: SQL Script window now remains open after disconnecting from the database
• When opening the data of a table with the primary key containing expressions, an error used to occur and the data were not displayed. Fixed now
• Index and View Editors: when creating a view or an index their description was not saved. Fixed now
• DB Explorer: after adding an object into the project it did not appear at the project tab. Fixed now
• DB Explorer: after refreshing the tree the functions whose owner was removed were not displayed. Fixed now
• DB Explorer: it was impossible to open a report or an index via the Recent Objects menu. Fixed now
• The 'Expand after connection' options were only applied to languages and tablespaces. Fixed now
• Field Editor: When changing object type from SERIAL to BIGSERIAL a wrong script used to be generated without taking the existing sequence into account. Fixed now
• The 'Reset all toolbars and menus' option used to work incorrectly in some rare cases. Fixed now
• Some options in the Replace Text dialog of the Query Data window used to work incorrectly. Fixed now
• Several bugs have been fixed that caused incorrect work of the program running on a system with dual display mode enabled
• Dependency Tree: the 'Save as image' button is now available on the navigation bar
• Now it is possible to resize the To-Do Item Editor window
• Enabling/disabling the 'Dollar-quoted function body' option could be applied only after program restart. Fixed now
• A large number of other small improvements and bug-fixes

Scroll to top

 

 Version 3.6.0.1

 

• EnterpriseDB server support implemented
• Export as SQL Script: now you can specify DBMS server for which the script should be generated
• Query Data: now it is possible to rename and move query tabs
• Query Data: query execution time is now displayed in hh:mm:ss format
• Query Data: in some rare cases during the query execution the Range Check Error message appeared. Fixed now
• Query Data: for the queries which allow data insert the ability to import data into the table implemented
• DB Explorer: the 'Add to Projects' command is added. Now objects can be added by specifying them in the corresponding dialog, and not only by dragging into the Projects folder
• DB Explorer: after table duplication the indices and triggers of the new table were not displayed in the tree. Fixed now
• Data Grid: the 'Expand All' and 'Collapse All' context menu items added
• Data Grid: the 'Save column sorting' option is added for the 'Save and restore layout' mode
• Data Grid: the 'Paste Cell' menu item didn't work in Lite version. Fixed now
• Data Grid: the SQL sorting mode used to work incorrectly with the field names represented by SQL keywords. Fixed now
• Data Grid: when scrolling the mouse wheel in the Print Data view DB explorer used to be scrolled also. Fixed now
• CPU usage significantly decreased
• Extract Database: fixed the bug with incorrect handling of the functions bearing OUT as a parameter
• Extract Database: the wizard used to work improperly with the tables named "char". Fixed now
• SQL editors: opening object editor with the Ctrl+Enter shortcut used to ignore its schema. Fixed now
• SQL editors: the Ctrl+Shift+Enter shortcut for pointing out the corresponding item in DB Explorer tree worked incorrectly. Fixed now
• SQL editors: SQL Formatter used to work improperly with ESC sequences in strings. Fixed now
• SQL editors: the 'Select All' command did not work correctly on text that had very long lines (more than 4096 symbols). Fixed now
• HTTPS protocol could not be used for HTTP tunneling. Fixed now
• Object file is displayed now in the DDL for the functions written in C
• Controls now remain in the toolbars after installing a newer version of the product. To bring them to their default state, you can use the corresponding command from Windows menu or the corresponding button in the Environment Options dialog
• Environment Options: applying the 'Table details in SQL Assistant' option did not have an effect on DB Explorer. Fixed now
• Import Data Wizard: when setting fields correspondence for import from Excel, selecting new column causes cursor to move to the first column in grid. Fixed now
• Database Registration Info: when applying changes, the originality of database aliases used not to be checked. Fixed now
• Database Designer: switching to another visual scheme did not take any effect on the context menu style. Fixed now
• Many other small improvements and bug-fixes

Scroll to top

 

 Version 3.5.0.1

 

• Ability to view and edit Server Configuration
• Query Data: Key Mapping is implemented to set the shortcuts for various commands/operations according to your needs
• Design Query: query execution plan is now displayed as a graphical diagram
• Dependency Tree: the diagram can now be printed
• Function, Domain, Sequence, Aggregate editors, Table Properties: now it is possible to change scheme for an object when using PostgreSQL server 8.1
• Function Editor: ability to edit function parameters if there are no objects dependent on this function
• Aggregate Editor: now you are able to edit aggregates
• Aggregate Editor: parameter type of an aggregate that does not examine its input values used to be shown incorrectly. Fixed now
• It was impossible to change an object name in the Edit User form. Fixed now
• Query Data: Next Bookmark, Previous Bookmark context menu items added
• Query Data: with the 'Trim trailing spaces' option on, an attempt to use Code Completion used to clear all the line. Fixed now
• Query Data: SQL Formatter now correctly works with TYPE CAST operation
• Query Data: dragging the field names from SQL Assistant works perfectly now
• Query Data: ability to execute a statement under cursor added
• Database Designer: there were no changes seen in opened graphical diagram when the table name or any table field was edited. Fixed now
• Database Designer: it was impossible to drop table via corresponding context menu item when just a field, not the table itself, was selected. Fixed now
• Database Designer: upon deleting field and following transaction rollback an empty error message used to appear. Fixed now
• Import Data Wizard: now with the 'Commit changes manually' option switched on at the end of import you will be prompted for an action with transaction
• Import Data Wizard: ability to resize wizard's window added
• Import Data Wizard: the 'Division by zero' error used to appear after importing data with the 'Commit changes manually' option switched on. Fixed now
• Import Data Wizard: upon setting format for fields to import, the 'Generator Value' and 'Constant Value' options used to be ignored. Fixed now
• Import Data Wizard: having specified user-defined fields to import, the rest of them were filled with empty strings; so that default values defined for the fields were not applied. Fixed now
• Data Grid: In the Lite version of the product the Grid Mode could not be changed. Fixed now
• Extract Database: server version is included into comments for the script now
• Extract Database: in CREATE TABLE statement the quotes before and after table name were missing. Fixed now
• Extract Database: upon extracting selected functions with 'Character and character varying as char and varchar' option enabled, functions with char and varchar parameters used to be skipped. Fixed now
• HTML Report: ability to change header/footer of the report added
• SQL Script: abort executing script confirmation added
• DB Explorer: it was impossible to open an index or a trigger via the Recent Objects menu. Fixed now
• DB Explorer: the context menu used to stay on top when switching between applications. Fixed now
• DB Explorer: after renaming a scheme, it was impossible to access its objects without refreshing the DB Tree. Fixed now
• DB Explorer: on attempt to delete the object and selecting 'Rollback' in Changing Metadata window it used to disappear from DB tree. Fixed now.
• Operator Editor: upon creating an operator containing an array-typed parameter, wrong use of quote symbols used to occur for its parameter type. Fixed now
• Table Editor: in some cases check constraints were not displayed in the Table Explorer tree. Fixed now
• When creating new sequences and following the 'Compile' action without changing any parameters, the sequence name used to remain empty in the generated script. Fixed now
• Table Editor, View Editor: on exporting subobject lists, strings larger than 32 symbols used to be truncated. Fixed now
• Many other small improvements and bug-fixes

Scroll to top

 

 Version 3.4.0.1

 

• Query Data: Query execution plan is now displayed as a graphical chart
• Full roles support on server 8.1
• Server Status service implemented
• SQL Formatter: formats SELECT, INSERT, UPDATE, DELETE queries (available from Query Data context menu)
• Italian localization added (Luigi Covato)
• SQL Script: now the process of script executing is shown and there is an opportunity to stop this process
• SQL Script: now you can open several windows at once
• SQL Script: when option 'Enable parsing' was enabled, editing a large script (> 10 M) caused hanging. Fixed now
• Data 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 the Grid | Advanced section of the Environment Options dialog)
• Data Grid, BLOB View: 'Word Wrap' option is added for text
• Data Grid: 'Set to Empty String' and other similar operations do not result in posting records in the table any more
• Data Grid: works correctly with OID fields that have no BLOB object for their values
• Data Grid: 'OID columns as BLOB' option added (except for fields with the name oid)
• Sequences can now be renamed
• Grant Manager: Permissions for groups are now displayed on server 8.1
• Grant Manager: When switching databases the 'Record index is out of bounds' error occurred sometimes. Fixed now
• Report Designer and Report Editor: support HTTP connection to database
• Design Query: saves queries between sessions
• Query Data: now there are no limitations for the size of edited scripts
• Database Registration Info: the feature Font Charset was not saved. Fixed now
• When there were any connected databases, the process of switching between program languages took a long time. Fixed now
• The needed documentation page did not open for some forms when pressing F1. Fixed now
• If a user who connected to the database did not have rights for all schemas, sometimes errors were emerged. The bugs are now fixed
• DB Explorer: after deleting the index or trigger, it was not deleted from the tree
• DB Explorer: did not work correctly for View function. Fixed now
• In some cases Design Query hung when parsing queries containing cast operator "::". Fixed now
• When deleting a table opened on the Data tab, the program used to freeze, or the operation was aborted by timeout. Fixed now
• Query Data border draws in accordance with the current visual scheme
• Function Debugger: The operation of getting array element according to its index resulted in an error when working with server 7.2
• Table Editor: double-click on the index in Table Explorer did not open its editor. Fixed now
• After renaming an object in DB Explorer, the context menu was not updated. Fixed now
• Other improvements and bug-fixes

Scroll to top

 

 Version 3.3.0.1

 

• German (Michael Albrecht), Dutch (Bert Herngreen) and Portuguese Brazil (Wilton Ruffato Wonrath and Rogerio Augusto Bassete) localizations are added
• Function Editor: IN/OUT parameters support, which appeared in PostgreSQL server 8.1, is added
• Copy Data to/from File wizards. CSV format support for server 8 and higher is added
• Group manager and User manager can work with HTTP and SSH now
• New Editor Options are added: "Trim trailing spaces", "Drag and drop text", "Group undo", "Keep caret horizontal position"
• Export/Import wizards: Items "Save Current Settings as Default" and "Reset Saved Settings" are added to Templates drop-down menu
• Code completion: did not work for table fields. Now fixed
• Code completion: required the exact correspondence of the object name case. Now fixed
• Code completion: when opened in modal forms, did not close by clicking Esc button. Now fixed
• Database Designer: the context menu for foreign key did not open - the "No argument for format" error occurred. Fixed now
• Window list: a context menu is added
• Field Editor: standard types, when entered in combo box for selecting the field type, are auto-filled now
• Grid: Moving column to the group field did not work with SQL Filter and SQL Sort options enabled. Fixed now
• Export Data Wizard: the 'Finish' button which can be pushed at any step is added
• Domain Editor: It was impossible to remove domain check constraint. Fixed now
• SQL editors: dragging of the selected text downwards worked incorrectly
• SQL editors: "undo" function after text dragging resulted in violation of the text integrity
• SQL editors: when going to the line number by clicking Alt+G, cursor position data in the status line did not change
• SQL editors: link did not work without the exact correspondence of the object name case
• Save settings: multi-line keyboard templates were restored empty from the file. Fixed now
• Keyboard templates: #Date tag gave the wrong date. Fixed now
• "Don't save query text" option is added in Query Data
• View Editor: empty bars on the Data tab appeared after closing the form. Fixed now
• When editing data in an updatable view 'Error while posting updates' message emerged. Fixed now
• Table Editor: if toolbars were disabled, navigation panes and toolbars under the Data tabs of all opened forms disappeared when closing the Environment Options dialog. Fixed now
• Enabling Allow parameters in SQL (the Tools section of the Environment Options dialog) was unavailable for open Design Query and Query Data widows. Fixed now
• Grid: filtering by the value that contains an apostrophe character did not work. Fixed now
• Function Debugger: for an erroneous function, an error message occurred twice when opening. Fixed now
• After import the data records were shown in grid in the reverse order. Fixed now
• Other small improvements and bug-fixes

Scroll to top

 

 Version 3.2.0.1

 

• Visual Design Query: support of subqueries and UNION joins
• Visual Design Query: ability to create INSERT/UPDATE/DELETE statements
• Grid: the 'SQL Filter' option added. Use the 'SQL Filter' and 'SQL Sort' options when limited number of records is fetched in the grid. They allow filtering and sorting records through all the dataset records, instead of only fetched ones
• Function Debugger: the value of a variable could not be changed. Fixed now
• When deleting a subobject from a table or view, there was no statement for confirmation of the operation. Fixed now
• The 'Sort by Aliases' option is now applied to all lists of registered databases in the program
• Reading database metadata is implemented without using transactions
• Extract Metadata: extracting data from big tables was slow and sometimes caused “Out of memory” error. Fixed now
• Extract Metadata: named argument functions were not shown after extracting selected functions. Fixed now
• Extract Metadata: while extracting tables WITHOUT OIDS and TABLESPACE keywords were not in the correct order. Fixed now
• Print Metadata: field types were not shown on table printing. Fixed now
• Print Metadata: primary keys which consist of several columns are shown now in PK column
• The 'Serial fields as integer in DDL' option is added
• Modal Visual Design Query form size is variable now
• Now you can disable deleting records confirmation
• HTML Report: a semicolon is added to tag '<&nbsp;>: <&nbsp;>'
• SQL Script: when executing a script from file, the file was uploaded to memory and then was executed. It did not work with big files. Now the script is executed directly from file
• Query Data: after deleting query, “save to file” might overwrite saved file
• Field Editor: the Code completion window of the default value editor was not closed after moving focus to another control. Fixed now
• Sequence Editor: the Backspace button did not work in the 'Next value' field. Fixed now
• Grant Manager: after changing an object type filter, the current position was not saved. Fixed now
• Program minimization did not work if the program was closed in the minimized state
• Field Editor: after entering a large number in the "Number of array dimensions" field the program failed
• Other small improvements and bug-fixes

Scroll to top

 

 Version 3.1.5.1

 

• Create Table and Create Field forms. Added composite types to the field type list
• When 'Enable floating toolbars' option was on it was possible to undock the main menu, but it was impossible to get it back. Fixed now
• Table Editor: 'Duplicate Field' and 'Copy List of Field Names to Clipboard' items of the field list context menu are returned now from version 2
• Query Data: 'Toggle Bookmarks' and 'Go to Bookmarks' items of the context menu did not work
• Query Data: after opening a form the focus was not placed on the editor
• Query Data: when calling 'Go to Line Number', 'Find', 'Save to File' using the corresponding shortcut in an active Log tab, the action was performed in fact in Edit tab editor
• Table Editor and View Editor: sometimes when switching to or from Data tab the Access Violation error arose. Fixed now
• Import Data Wizard, import from Access: fixed the bug with loading from template: fields map wasn't loaded
• Import Data Wizard, import from MS Excel: fixed the bug with moving column cells with Skip Rows equaled to 0 and empty first column cell
• Added infinity values support in grid which was previously implemented in version 2
• Extract Metadata: data from tables which had inherited tables were extracted incorrectly that led to duplicating records in the inherited tables. Fixed now
• SQL Script: with double semicolon (;) character in the script, filling the statement tree stopped at this point. Fixed now
• DB Explorer: in the context menu 'Remove from Project' and 'Drop ...' items had the same shortcuts. Fixed now
• Load Data Wizard: the progress indicator showed 50% after finishing a task. Fixed now
• Other small improvements and bug-fixes

Scroll to top

 

 Version 3.1.0.1

 

• Copy Database Wizard implemented
• Now the program notifies itself of new versions released and updates the needed files when SQL Manager Direct is enabled for automatic update
• Code completion: for table fields their types are shown now
• DB Explorer: visible/Invisible tab state is saved now
• DB Explorer: in MDI mode shortcuts on additional tabs didn't work correctly. The bug is fixed
• DB Explorer: on opening Create menu an Access Violation error emerged if the current tree node was host. The bug is fixed
• DB Explorer: visible/invisible SQL Assistant state wasn't saved in MDI mode. The bug is fixed
• DB Explorer: pressing Enter for a table opened its editor and also first table field editor. The bug is fixed
• DB Explorer: incremental search didn't work on additional tabs. The bug is fixed
• The TAB key can now be used to shift focus to the next cell in data grid
• When connecting through SSH, the 'SSL mode' option was not ignored. Now fixed
• Grid / Form View: checkboxes for setting NULL field value were not shown. Now fixed
• Surplus object refreshes were made when connecting to a database, which retarded connect on slow lines. The bug is fixed
• Code completion: the list did not include SQL keywords. The bug is fixed
• Query Data: with grid filter set in Load Visible Rows mode 'Syntax error' arose on posterior executing of another query. The bug is fixed
• SQL Script: if there were empty operators limited by the semicolon ';' sign in the text, script execution stopped at this operator. The bug is fixed
• Table Editor: if object description was not saved when closing form, save request emerged and regardless of the choice the description was saved. The bug is fixed
• When closing the program some forms closed without showing save request. The bug is fixed
• Query Data: if a query returned rows in enabled transactions mode, the transaction was committed when executing any posterior query. The bug is fixed
• SQL editors: after closing Environment Options with save, the cursor restored insert/override mode in SQL editors according to program settings. Now fixed
• Extract Metadata: when extracting from a non-connected database the list of schemas was not filled. The bug is fixed
• Other small improvements and bug-fixes

Scroll to top

 

 Version 3.0.0.1

 

Basic features:

 

Latest PostgreSQL versions support

• Compatible with any PostgreSQL versions up to 8.0
• Changing column types
• Tablespaces support
• Support of argument names in functions
• Support of dollar-quoted strings

Significantly improved user interface

• Office 11 and Windows XP visual schemes support
• New well-described Wizard System
• New useful Navigation bars in most of the program windows
• New Windows Toolbar to switch between windows, like Windows Task Bar

Improved Database Explorer

• Creating tabs for any tree node to access it in one-click
• Working with multiple selected objects at a time
• Much more convenient toolbar and context menu

Completely remade Database Designer

• Obvious new look
• Two diagram notations (IDEF1x and IE)
• Improved diagram navigation
• Several pages in one diagram to divide diagram into different subject areas
• A lot of visual customization options

New powerful data management tools

• Plenty of useful tools such as data grouping, summarizing, fast searching and filtering
• Master-Detail View to work with two linked tables at the same time
• Table and Card Views to see data the way you like
• Ability to copy and paste selected records
• Advanced printing system
• Fully customizable interface

New connection options

• Access to PostgreSQL server through HTTP protocol in case of Internet access through HTTP proxy only, or if the server doesn't allow direct connections to PostgreSQL
• SSL connections support to encrypt client/server communications for increased security. Most suitable in case of Internet connection

Improved report management

• The new Create Report Wizard allows you to create a simple report in a few clicks
• Managing reports in the same way as if it were a database object: accessing reports directly through the DB Explorer tree

and more...

Scroll to top

 

 Version 2.8.0.1

 

• Function Editor: now you can run functions and get their results right from the editor
• Query Data: implemented the ability of viewing query plan without a need to run it; new options to receive the plan added: Verbose and Analyze
• We have added support for partial indices
• Create table form: improved editing abilities in the Fields grid
• DB Explorer: now when creating an object, the current schema from DB Explorer is selected as its schema
• Grid: sometimes minutes from date/time fields were saved incorrectly. The problem is solved
• Query Data: For queries returning incomplete field set, updating a record could cause incorrect results. Fixed now
• Sometimes when renaming indices an incorrect script was generated. The bug is fixed
• Shortcuts for tabs didn't work. Now it is solved
• Print Data table view: defining column width worked only with 'Get column's width from Grid View' option checked. Fixed now
• Solved the problem when the state of the main form's window was not restored when running the program
• Query Data: a number of error messages arose after selecting another database and then changing the window size. Fixed now
• When running the program, you could not shut down Windows. The bug is fixed
• Database Registration Info: fixed a bug with 'ISO-xxx' client encoding values that did not work correctly
• In the DB Explorer context menu the 'Drop Database' item was always disabled. Now solved
• To-Do List: fixed the bug with a second copy of an item that appeared when editing it
• Now a column with the dot symbol in its name can be deleted
• Database Designer: resizing the border of a table and clicking on empty space below fields caused the Access Violation error. The bug is fixed
• Some other minor improvements and bug-fixes

Scroll to top

 

 Version 2.7.0.1

 

• Extract Metadata: added the possibility to make scripts for all objects of a schema
• Query Data: now it is possible to view the query results on the same tab with the query text
• When connecting to the server 8.0beta5 an error arose, as in this version of the server it is impossible to define tablespace for schema and, therefore, in the system table 'pg_namespace' there is no 'nsptablespace' field. The appropriate changes are made in PostgreSQL Manager.
• SQL executor now supports dollar-quoted strings
• In function definition the function body is now shown as a dollar-quoted string. You can disable this using the 'Dollar-quoted Function Body on Server 8.0 and Higher' option on the Object Editors page of the Environment Options dialog
• There is new possibility to disable showing the Changing Metadata window using the corresponding option in the Confirmations section of the Environment Options dialog
• Design Query: an Access Violation error emerged when adding a criterion and closing the form. Fixed now
• 'Make hidden Table Explorer visible on new table window' option is substituted for 'Hide Table Explorer'. A new button is added to the Table Editor toolbar to show/hide the explorer
• Expressions of indices for server 8.0 beta 5 are shown correctly now
• Now, when creating SERIAL and BIGSERIAL on server 8.0, the script like ALTER TABLE ADD SERIAL is generated. On creating SERIAL on server 7.4 and lower the maximum value for created sequence is limited now according to INTEGER type
• BLOBs with OID more than 2147483647 were shown empty. The problem is solved now
• The error arose and the views were not shown when the user without rights on some schemas usage tried to connect to server. Fixed now
• Function Editor: sometimes after compiling a function the list of arguments became empty. Fixed now
• Export Data Wizard: when the 'Current record only' option was selected, the cursor jumped to the first record and the first record was exported. Now solved
• Environment Options dialog, Grid section: the new 'Autofill Not Null fields w/o default' option is added
• Now the Help | 'Send bug report to' main menu item is passed to our Support Ticket System
• Small improvements and bug-fixes

Scroll to top

 

 Version 1.4.0.1 (Linux)

 

• We have improved the compatibility with different Linux versions
• SSL connections management is supported now
• We have added the support of array field types in the data editing window
• We have added the possibility to enter a unix-socket instead of the port number like "/tmp/mysql.sock", i.e. to connect to the local server with disabled TCP/IP
• We have implemented an installer. The program is distributed as a sh-script now instead of archives
• Several bugfixes in design: displaced fonts, wrong control sizes, invisible combo box captions, etc.
• Closing the help file often caused the program hang-up. Fixed now
• The majority of open/save dialogs didn't show files due to the incorrect filters. The issue is resolved
• We have significantly improved the usability of .txt files importing page
• Fixed the bug with SQL-Monitor. Now it works correctly after reopening
• Several serious errors in print preview window are fixed now
• The bug in register database window caused the 'out of bounds' message. Fixed now
• Fixed the bug with data editing in tables with bigint fields
• The problem with execution of the scripts with '--' comments is fixed now

Scroll to top

 

 Version 2.6.0.1

 

• We have added tablespaces support on working with server 8.0
• DB Explorer: now allows renaming schemas, tables, fields, check constraints, functions, triggers, aggregates, languages. You can disable renaming in place by using the 'Rename objects by editing in place' option
• Now Grant Manager opens and works faster
• Function Editor: now argument names that have become available in server 8.0 are supported
• An ability to rename users and groups for server 7.4 and higher is added
• Field Editor: now allows setting the level of detail of statistics accumulated for a column by ANALYZE
• Foreign Key Editor: now you can set or change match type of a foreign key
• Now Function and Trigger editors allow showing/hiding header part of the windows that enlarges the definition editing area. The Environment Options dialog contains options that allow auto hiding a header on opening the editors
• When a view was recreated, its rules were not recreated and were lost. Fixed now
• Dependency Tree: now on opening the select object dialog is shown
• Grant Manager showed privileges incorrectly on system functions. Fixed now
• Grant Manager didn't show privileges of users whose names contain a dash
• Code completion: When on entering alphanumerical characters to press Space or shift the cursor, the demonstration was not canceled
• Code completion: If one typed several characters and pressed Enter for insertion of the word when Code Insight is open - the word was inserted, but Code Insight emerged again. Fixed now
• When an error occurred on database creating, the second launch after correction of creation parameters returned an access violation error. Fixed now
• Now Design Query encloses tables' and views' names with upper case letters in quotation marks
• Grid: If the cell isn't in edit mode when editing the integer field value - on pressing a numerical key and further saving of corrections the previous grid cell value was restored
• Database Designer: in some cases, when choosing the not-white window color in the monitor settings, a black square emerged on printing a Database Designer diagram
• Now the default button of the dropping database confirmation dialog is Cancel
• Query Data: now when dropping query pages, the confirmation dialog emerges
• Small improvements and bug-fixes

Scroll to top

 

 Version 2.5.0.1

 

• Table Editor: now you can cluster your tables using the new Cluster Table service. This service is accessible through the corresponding button on the Table Editor toolbar
• Print View: now you can customize columns width using the new dialog that is accessible through the Table Column Widths button on the toolbar
• Now you can connect to PostgreSQL server v7.5-devel (native Windows version)
• Export to Excel: added an ability to set values of the defined cells, merge cells, and define the page background
• Import wizard: added an ability to define the error log file name
• Now you can update and delete table records by only the unique identifier of the record (i.e. primary key or unique index) instead of the complete record value (all fields). To make this feature available check the Use Key Fields Only switch on the Grid page of the Environment Options dialog
• Print View: now the program saves page settings. You can disable this feature on the Reports page of the Environment Options dialog
• Now the program correctly shows results of the FETCH statement
• Query Data: added the Explain Query item to the Run drop-down menu on the toolbar. Check this item to show/hide the query execution plan when executing the query
• Export as Insert: now the program exports data from views regarding to the current filter settings
• Fixed a bug that caused the 'Error while posting updates' error when updating the TIME field set to 00:00:00
• Fixed a bug in the code completion system that slowed down the processor if the selected localization differed from the default one
• Function Debugger, Modify Variable dialog: now the program correctly drops the NULL flag when changing values of fields. The "Invalid variant type conversation" error appeared when opening NULL fields is fixed now
• The 'Field XXX must have a value' error appeared when trying to save data of the BLOB field with the NOT NULL flag checked. Now it is fixed
• Fixed a bug that caused the 'Invalid field size' error when trying to execute SELECT statements that contain the bytea statements (i.e. function calls that return bytea statements)
• Design Query: now the program correctly parses LIKE statements
• Design Query: now the program correctly builds query if the table has two or more links
• Design Query: now you can drag and drop tables to the work area without any difficulties
• Data Grid: fixed a bug with the improper disabling of the navigation buttons
• Fixed a bug with usage of fonts that are defined in the Environment Options dialog
• Now the program correctly adds the name of the newly created view to the DB Explorer tree
• Form View: now the program correctly displays NULL values of date and time fields
• Some small improvements and bug-fixes

Scroll to top

 

 Version 2.4.0.1

 

• Query Data: now you can use the Shift+Ctrl+Space key combination to view function parameters after you enter a function name in your code
• Now the program supports domain checks in PostgreSQL 7.4
• Duplicate Table: in this version you can copy the table data along with the table structure
• Table Editor: now you can create an updatable view for the table
• Design Query: now you can create views that are based on queries
• Now the program asks for a confirmation to load all table records when exporting data if the grid record limit is on
• Print Data View: now the program displays the table name on each page of the report
• The Database Metadata Log now contains only records that are executed completely and not rolled back
• The Database Query Data Log now contains only statements that are executed successfully. You can disable this feature using the corresponding option on the Query Data page of the Environment Options dialog
• Function Debugger: several improvements and bug-fixes in the variable list
• The "'' is not a valid integer value." error that appeared when opening a PostgreSQL 7.4 table with a unique INDEX BY statement is fixed now
• Database Designer: fixed a bug that caused an error when creating links from the drop-down menu of the table
• Edit Field: fixed a bug that caused an error when displaying dimensions of an array field
• The "Control has no parent window" error does not appear anymore when starting the program if DB Explorer was hidden in the previous session
• SQL Script: now the program correctly saves scripts upon pressing the Ctrl+S shortcut
• Fixed a bug that caused high processor load when typing text in Query Data if the selected interface language differed from the default one
• Fixed a bug with a button on the Form View tab that shows BLOB content
• Extract Metadata: Now the program correctly reports about all errors that appear during the extraction process
• Some small improvements and bug fixes

Scroll to top

 

 Version 2.3.0.1

 

• We have implemented a new form for creating tables. Now it allows you to define all the table fields before table creation
• Database Registration dialog: now you can keep connection with the server alive by checking the Ping Server Every ... Seconds and setting the period between pings
• Data Grid: now you can filter data in the 'Load Visible Rows' mode
• Data Grid: now the program exports only the filtered data
• Data Grid: now navigator buttons are correctly enabled in 'Load Visible Rows' mode
• Data Grid: now the program correctly refreshes data if the table or query contains memo fields, BLOB fields, large string fields, or array fields
• Query Data: the 'ERROR: current transaction is aborted, commands ignored until end of transaction block' error that appeared when executing large queries is fixed now
• Now you can disable the Table Explorer for the current window only
• Extract Metadata: now you can extract the CHARACTER and CHARACTER VARYING fields as CHAR and VARCHAR. The option is added to the Extract Options tab of the dialog
• Now the program supports the 'infinity' value of TIMESTAMP fields
• Reduced the amount of virtual memory that is required for saving BLOB objects to the database
• Export Data: now the Export dialog automatically adds the file extension to the file name; fixed a bug with exporting data to CSV
• Fixed several bugs in the Find/Replace commands of the text editor. Now you can use the Ctrl+R shortcut to call the Replace Text dialog
• SQL Script: now the word wrapping system works correctly in the Messages window
• Small improvements and bug fixes

Scroll to top

 

 Version 2.2.0.1

 

• Significantly improved the data grids: now the data grids support array fields; also added the new navigation panel that is more convenient to use
• The Code Insight system now supports aliases in SELECT queries
• Report improvements: XLS and bitmap export, hypertext and URL links in designer and many more
• We have added Romanian localization to the installation package
• We have updated the Export Data dialog and fixed some bugs in the export process
• Data Grid: reduced the memory usage and added the Copy and Paste items to the drop-down menu
• Grant Manager: fixed a bug with displaying permissions for PostgreSQL v7.4
• Register Database dialog: added the 'Login prompt before connection' option for SSH connection. The 'Copy Alias from' button works correctly now
• Design Query: Now you can show/hide system fields. Use the 'Show System Fields' option on the Design Query tab of the Environment Options dialog
• Environment Options: We have added the 'Convert line end to Linux style in string constants of executed SQL statements' option to the Tools section
• SQL Script: fixed a bug with the Rollback on Abort option. The Client Encoding and the SQL Timeout parameters works properly now
• View Editor: fixed a bug with compiling views which contained fields with names in uppercase
• Fixed bugs with primary and unique keys when recreating tables
• Fixed a bug with script generation when editing BIGSERIAL and SERIAL fields
• The Extract Metadata tool generated one-row views' DDLs. Fixed now
• We have fixed up the parser that forms SELECT statements in views' DDLs
• Fixed a bug with generating script when creating TIME or TIMESTAMP array fields
• Create/Drop Database: fixed bugs with SSH connection
• Some small improvements and bug-fixes

Scroll to top

 

 Version 1.3.0.1 (Linux)

 

• Now PostgreSQL Manager supports the PostgreSQL Server v7.4
• Other small improvements and bug-fixes

Scroll to top

 

 Version 2.1.0.1

 

• We have implemented the Dependency Tree tool. Now you can view all the object dependencies in one diagram. To call this tool use the Tools | Dependency Tree main menu item
• Plpgsql Function Debugger now supports cursors. Besides, we have fixed several bugs in the debugger
• Several bug fixes in the Extract Metadata Expert. Now this tool generates correct scripts for all objects
• Import from MS Access: One table appeared several times in the table list. Fixed now
• The Duplicate Table function now works correctly for PostgreSQL v7.2
• Sequence Editor: Fixed bug with saving changes of the Next Value field on PostgreSQL v7.4
• Create Database: Now you can create databases through the SSH connection
• Now Query Data correctly returns results of the EXPLAIN operator execution on PostgreSQL v7.3 or higher
• User Manager and Group Manager: added the System ID column
• Lost names of foreign keys and checks on table recreate. Now fixed
• Some small changes in function, sequence, and table DDLs
• Other small improvements and bug-fixes

Scroll to top

 

 Version 2.0.0.1

 

Basic features:

 

Support for PostgreSQL 7.4

• Now PostgreSQL Manager fully supports PostgreSQL server v7.4

Database Designer

• The Database Designer is implemented. Now it is possible to design your database intuitively using this tool. A lot of features are implemented including reverse engineering, foreign keys support and diagram printing/saving/loading. Customizing of the Database Designer is available on the Options | Environment Options | Tools | Database Designer page

Plpgsql Function Debugger

• To fix errors or optimize function code you can debug the function step-by-step before compilation, using the Plpgsql Function Debugger. To activate the debugger open the function in Function Editor, then click the "Debug Function" button on the toolbar

HTML Report Generator

• Now you can generate detailed reports about your database in HTML format. You can call this tool by selecting the "HTML Report" item from the "Tools" menu

Internal SSH client

• An internal SSH client has been implemented in PostgreSQL Manager. Now it is possible to connect to a remote PostgreSQL server using local port forwarding through the SSH (Secure SHell) tunnel. All the necessary parameters for SSH connection are available in the SSH section of the Database Registration Info dialog, and on the first step of the Register Host Wizard

A number of improvements

• Improved Data Export and Data Import Wizards: Now you can add charts based on exported data to Excel documents and import data from Excel sheets and XML files
• Now the program tries to restore the broken connections with the server
• We have fixed an error on saving BLOBs
• Now grids automatically switch to the "Load Visible Rows" mode on opening queries with a large amount of result rows
• Now the program allows you to create an Index when creating a foreign key if the referenced table has no index for the foreign key
• Now the program automatically adds appropriate operators to the script when creating the primary key if the NOT NULL option is unspecified for the fields
• Some minor improvements and bug-fixes

and more...

Scroll to top

 

 Version 1.8.0.1

 

• The Extract Metadata Expert now builds scripts according to the dependencies between objects
• Added an ability of incremental search to many of the program lists
• Names of the new objects are converted to lower case on typing now if the "Convert created object's names to lower case" option is checked. You can find this option on the Preferences page of the Environment Options dialog
• A bug with the "Error while posting updates" message appearance during updating records in a table containing REAL and TIMESTAMP fields, is fixed now
• Fixed a bug with 50-char limit for displaying or editing values of VARCHAR fields with undefined length
• During work with a table which contained CHAR/VARCHAR fields with length greater than 8000 chars, the "Invalid field size" message appeared. Fixed now
• DB Explorer opened on the Windows tab at the program startup. Fixed now
• Fixed a bug with deleting a wrong function if the database contains two functions with the same names which differ only in char case
• Fixed a bug with the incorrect DB Explorer tree refreshing after creating functions in some cases
• Function duplicating in DB Explorer works correctly now if the grouping option is checked
• PostgreSQL v7.1: some functions were not determined as system functions. Fixed now
• Table Editor, Duplicate Field: a table name in the UPDATE statement is quoted now.
• Fixed a bug with restoration of privileges on views and sequences after their recreation
• Form View: the Not Null option was dropped only after the record saving. Fixed now
• Reindex: now index names include namespace
• Export Wizard / Import Wizard: the initial directories to save/load templates are set correctly now
• Shortcuts for labels work correctly in all forms now
• Table's DDL: Names for SERIAL and BIGSERIAL fields are quoted now
• Function's DDL: the return value type is quoted now
• Query Data: all options from the Transaction Confirmation group work correctly now
• Query Data: the "column number 4 is out of range 0..3" message doesn't appear any more during the query execution
• Now Query Data shows correctly all the available notices
• Query Data / Design Query: the Help buttons do not exist any more
• SQL Script: the 'Rollback on Abort' option works correctly now
• SQL Script: statement ranges were not detected correctly in some cases. Fixed now
• Now Grant Manager generates correct scripts for setting the function's owner and for defining grants for functions with large amount of parameters
• User Manager / Group Manager: the grid shows all the columns on startup now instead of only last as in previous versions
• Now User Manager and Group Manager detect SUPERUSER even if the user name contains characters in upper case
• User Manager / Group Manager: the "User 'xxx' has no privilege to edit users" used to appear twice. Fixed now
• Several minor bug-fixes and small improvements

Scroll to top

 

 Version 1.2.0.1 (Linux)

 

• Now you can view the dependencies of the database objects at the appropriate editor tabs. The Environment Options dialog contains two new options on the Tools tab: 'Automatically expand dependencies' and 'Don't show empty object categories in dependencies'
• Transactions in grids: In order to decrease a probability of other programs' hang up on editing table editors in PostgreSQL Manager, we have added a possibility to disable transactions in grids. For this purpose 'Use transaction' option on the Tools tab of the Environment Options dialog is provided. If it is on, the grid works as in previous versions: the transaction is active until the grid is closed or the Commit button is pressed; all edited records are blocked until the transaction commit. If this option is off, then the transaction starts and immediately commits (autocommit) on saving each record, which is blocked only for a little time period
• We have added the statement timeout support for working with server v7.3. You can customize timeouts on the Tools page of the Environment Options dialog. Timeouts are necessary for preventing program hang-up when executing the SQL statement due to the transaction interlocking
• Now on error in query Query Data tries to find the position of the error in the SQL statement
• Export as Insert is being called properly now from the Query Data
• Query Datas: Now you can disable the Smart Tabs mode (when the tab positions are set according to the space characters in the previous non-empty lines). The appropriate options are added to the Editor Options dialog
• Fixed bug with incorrect saving comments and formatting during saving query in the Query Data
• Some small corrections and improvements

Scroll to top

 

 Version 1.7.0.1

 

• We have added the statement timeout support for working with server v7.3. You can customize timeouts on the Tools page of the Environment Options dialog. Timeouts are necessary for preventing program hang-up upon execution of a SQL statement due to the transaction interlocking
• We have implemented the new Trigger Editor
• We have added a new tool - Report Designer. It is a powerful tool for designing reports visually
• The connection speed is significantly increased with the 'Show table subobjects' option on
• Incremental search in DB Explorer
• Now on error in query Query Data tries to find the position of the error in the SQL statement
• The Print Metadata tool now prints all the table subobject descriptions
• The Filter Builder dialog is localized now
• Now you can use the Ctrl+G key combination for switching between the page control tabs
• The 'Use transaction' option is now located in the Tools section instead of the Grid section of the Environment Options dialog and has effect on the Query Data and Design Query behavior
• Script is being generated correctly now on updating a table record
• The program does not hang up any more on changing metadata if a table is open and the "Use transaction" option is disabled
• The SHOW statement executes correctly on server 7.3 in Query Data now
• Now Export as Insert is called properly from Query Data
• No error occurs any more on closing Function Editor, if the edited function had plenty of arguments
• The TIMESTAMP fields can be edited without any errors now in the Form View mode
• If Table Editor was closed with the Data tab being active, then on reopening the table its records were loading twice. Fixed now
• Fixed a bug with multiple display of the grid column after the table recreation or field renaming with the "Save grid view" option on
• Column widths after changing it and committing transaction with the "Save grid view" option on do not return to their previous values
• The "Save grid view" option now takes effect on View Editor as well as on other grids
• The Final Type box now displays correctly in Aggregate Editor
• Fixed bug with the triggers with their functions removed
• No error occurs any more on trying to create an index with a "." sign in its name on server 7.2 or 7.1
• Fixed error with displaying the PUBLIC group in the group list of the User Editor dialog
• Some minor improvements and small bug-fixes

Scroll to top

 

 Version 1.1.0.1 (Linux)

 

• Environment Options: A possibility of defining Qt style is added
• DB Explorer: The "Add to project" dialog is improved. You can add, delete or modify folders or subfolders of the project from this dialog
• Main Form: The Database->New Object and Database->Duplicate Object menu items are added
• Main Form: A possibility of starting other our utilities (PostgreSQL Export, PostgreSQL Import, PostgreSQL Extract) from main form is added. If you've installed some of EMS PostgreSQL Utils, the program will automatically add proper buttons to the Utils toolbar on Main Form for fast calling these utils from PostgreSQL Manager
• Trigger Editor: A possibility of creating or editing corresponding function is added
• Data Frame: The "Set Filter..." context menu item works correctly now
• Server v7.3: Fixed bug with incorrect script generation for creating functions with an argument like ..
• Field size for TIMESTAMP, TIMESTAMPTZ, TIME, TIMETZ, and INTERVAL shows correctly now
• Fixed bug with incorrect script generation on adding a TIMETZ field to the table
• Field size and precision for NUMERIC show correctly now
• Some small improvements and corrections

Scroll to top

 

 Version 1.6.0.1

 

• Now you can view the dependencies of database objects at the appropriate editor tabs. The Environment Options dialog contains two new options on the Tools page: 'Automatically expand dependencies' and 'Don't show empty object categories in dependencies'
• Transactions in grids: In order to decrease a probability of other programs' hang up on editing in table editors in PostgreSQL Manager, we have added a possibility to disable transactions in grids. For this purpose 'Use transaction' option on the Grid page of the Environment Options dialog is provided. If it is on, the grid works as in previous versions: the transaction is active until the grid is closed or the Commit button is pressed; all edited records are blocked until the transaction commit. If this option is off, then the transaction starts and immediately commits (autocommit) on saving each record, which is blocked only for a little time period
• Table DDLs now display SERIAL and BIGSERIAL fields correctly
• SQL editors (Query Data, SQL Script): Now you can disable the Smart Tabs mode (when the tab positions are set according to the space characters in the previous non-empty lines). The appropriate options are added to the Editor Options dialog
• Insight List: Now object names containing capital letters are enclosed in quotation marks
• Server v7.3: Fixed a bug with incorrect script generation for creating functions with an argument like ..
• Now program works correctly after selecting language at the first startup
• Server v7.3: Sequences for fields SERIAL, BIGSERIAL are no more dropped if a table is edited through recreation
• Field size for timestamp, TIMESTAMPTZ, TIME, TIMETZ, and INTERVAL shows correctly now
• BIT, BIT VARYING, TIMESTAMPTZ, and TIMETZ fields are displayed in the grid correctly now; no errors occur on refresh
• Fixed a bug with incorrect script generation on adding a TIMETZ field to a table
• No error occurs on changing a field type from any integer to BIGSERIAL now
• Fixed an error with selecting value editor type after reordering columns with the 'Save Grid View' option on
• Incorrect script was generated for some of the DB objects on saving a comment with a ' character. Fixed now
• No error occurs on dropping a view or rule through DB Explorer any more
• All experts use right DB name on their startup now
• Register Host Wizard now displays the error message if an error occurs on connecting to server
• Printing metadata can be called successfully from Index, domain or schema editor now
• Case Code does not modify object names any more
• Fixed an error with hiding database objects in DB Explorer after deleting the user that owned these objects

Scroll to top

 

 Version 1.0.0.1 (Linux)

 

The Linux version of PostgreSQL Manager - a powerful GUI tool for PostgreSQL database administration and development.

 

PostgreSQL Manager for Linux is the same powerful tool for PostgreSQL management as the Windows version. It provides graphical interface for all basic operations: creating/dropping databases, creating/dropping/altering tables, views, functions and other database objects, managing table data, running SQL queries and scripts, etc. Export/import data to/from most popular formats and other unique features are also available in Linux version.

Scroll to top

 

 Version 1.5.0.1

 

• MDI Interface implemented. Microsoft Office Style - all program windows are child windows of the main window now. You can customize the Environment Style using the Environment Options dialog
• Two new localizations added - Italian and French
• The support of composite types for PostgreSQL v7.3 is implemented
• The 'Autoconnect on Startup' option was added to the Database Registration Info dialog
• Table Editor: the Comment columns are added to the lists of fields, foreign keys, checks, indices, rules, and triggers
• Table Editor | Fields: foreign keys are now indicated with icons similar to primary keys
• The "Set Defaults to All Child Windows" item was added to the Windows menu. This item sets all the child windows to their default sizes and positions. This function is also available through the Ctrl+Alt+D shortcut
• Database list in child windows are now grouped by hosts if the Show Hosts option is enabled
• The new option 'Show only connected databases in drop-down menu' can be found on the Tools page of the Environment Options dialog
• Now the cursor position is displayed in the SQL areas of view, function and rule editors
• The caption of the focused column in the grid is now displayed in bold
• Autofit column widths in the grid works subject to the column name
• Now you can select custom color from the color select drop-down list on the Grid page of the Environment Options dialog
• NUMERIC type without setting precision and scale is supported now
• Table's Details submenu in the View Mode menu of DB Explorer is now duplicated in the View main menu
• The following buttons are added on the View editor toolbar: Commit, Rollback, Export Data, Export as INSERT, Import Data, and BLOB Editor
• Design Query: now you can select the sorting mode of the table list, and also drag tables and views from DB Explorer
• Environment Options dialog, Confirmations section: options enabling/disabling confirmation of transaction commits and rollbacks added
• Fixed a bug on v7.3 server with the impossibility of editing tables from not-default schemas
• Design Query on server v7.3. Table names are being written with their namespaces, all the tables and views are displayed, not only from the default namespaces
• Now on reordering fields, deleting a field, changing the field name or type, the ALTER TABLE OWNER TO statement is not executed if the current user is the table owner
• A table is not recreated on changing only a field name
• On server v7.2 tables with foreign keys are not any more edited by recreation
• The program does not hang up any more on creating/opening a view if a value in the Right Margin editor box on the Display page of the Editor Options dialog is less than 12
• Now script for editing index on server v7.3 with options Primary or Unique off is generated correctly
• Now index on v7.3 server created with the CREATE UNIQUE INDEX statement is deleted correctly
• The Code Case parameter on the Quick Code page in the Editor Options dialog works properly now
• Fixed bug with displaying only tables and functions in the Windows | Close submenu
• Database objects are refreshed completely on changing the database in the editor now
• The toolbars of the object editors are saved properly now
• Fixed a bug with localizing several forms of some object editors
• The trial form is localized now
• Window list is updated on creating a new database object now
• Fixed several bugs with deleting table subobjects
• On adding SERIAL and BIGSERIAL fields the NotNull and Unique options are set now
• Several minor improvements and small bug-fixes

Scroll to top

 

 Version 1.4.0.1

 

• A possibility of dropping a table field for servers lower than 7.3 and a possibility of altering the field type added. These operations are implemented through recreating the table. You can use the appropriate options on the Environment Options | Confirmations page to forbid these features
• Data Export and Import are significantly improved. Export to MS Access and PDF and Import from Access added. Now you can export data to as much as 14 formats and import data from 5 formats
• Table Editor and View Editor: now column widths for all the tabs are saved
• The Field Editor interface improved
• Now on dropping table subobjects in Table Editor a confirmation dialog appears
• The 'timestamp without time zone' type is interpreted correctly now
• Now you can edit BIGINT fields freely
• Fixed bug with setting the length of the BIT fields and defining the length of the BIT and BIT VARYING fields
• Boolean fields are displayed correctly in the Form View mode
• Copy to clipboard / paste from clipboard functions work properly now in the Query Data and Design Query grids
• Reordering fields referenced by some foreign keys is restricted now
• On reordering fields permissions for the table are restored correctly now
• Fixed a bug with the 'table doesn't exist' message on selecting a table in DB Explorer, if on reordering table fields the Rollback button was selected in the Compile Window and the Cancel button in Re-order Columns
• Dropping a table is forbidden now, if table is opened on the Data tab in Table Editor
• Integer overflow error does not appear any more on deleting table subobjects
• Some minor improvements and small bug-fixes

Scroll to top

 

 Version 1.3.0.1

 

• New data grid: Now it can work in two modes: "Load All Rows" and "Load Visible Rows". The first mode provides some additional features, such as filtering fields, sorting data be several fields, etc. However this mode works slower on tables with large amount of records. The second mode works just as in previous versions. According to this a new option "Load all rows mode as default" appeared on the Grid page of the Environment Options dialog, and in the popup menu a submenu appeared, which allows you to select a mode: "Load All Rows", "Load Visible Rows", or "Default". If you select the "Default" item, the mode is selected according to the option "Load all rows mode as default". The selected mode is stored individually for each table. You can also use another new option "Row multi-selection" on the Grid page of the Environment Options dialog. If this option is enabled, you can select multiple rows in a grid, but in this case navigation in tables with large amount of records is slower
• Unicode database support - now you can define the client encoding and font char set in the Register Database and Register Host dialogs
• Functions, returning SET OF are supported now. The appropriate options added to Function Editor
• Changes in the table Form View: field type is displayed in the field name hint; the Null option is not visible if a field cannot be Null; string and memo fields expanded to the window width
• Parameters in Analyze and Vacuum services are described more precisely
• The 'Inherits From' list in the Create Table dialog redesigned
• In the Environment Options dialog a new page has been added - Tools | Reports, where you can set the sheet size for the reports
• A possibility to set column widths for Print Data table view added. Use option "Get column's width from Grid View" on the Reports tab of the Environment Options dialog
• The Find and Replace text functions added to Localization Editor (called by Shift+Ctrl+L)
• All objects are recreated correctly now while reordering fields
• Fixed bug 'List index is out of bounds', which rarely appeared on reading the foreign key on server 7.2
• The update script is generated correctly now on setting the Unique options while editing a field
• Object descriptions are displayed with word wrap now
• Fixed a bug with displaying query results in Query Data with some definite settings enabled
• A bug with the "SQL Monitor Options" button in SQL Monitor is fixed
• Now you can set names longer than 31 characters for all the objects on server 7.3
• In the Form View of the Results tab in Design Query and Query Data fields are no more available for editing for non-alive queries
• The Returns drop-down list in Function Editor now contains complex types (i.e., table's row types)
• View Editor for server 7.3: Now on renaming a view or one of the view's columns the update script is generated as CREATE OR REPLACE VIEW, instead of DROP - CREATE VIEW
• Fixed a bug with impossibility of entering some specific characters in the code editors with AltGr
• Object comments which contain an apostrophe (') symbol are now saved correctly
• Fixed a bug with loading visual settings on program startup
• Fixed a bug with adding SERIAL and BIGSERIAL fields to a table
• A lot of other bug-fixes and small improvements

Scroll to top

 

 Version 1.2.0.1

 

• Full PostgreSQL server v7.3 support
• Name space support: Now a box for setting object name space is added to each object editor, and database objects in the DB Explorer tree and in all object editor trees are divided by schemas. You can create, edit and drop database schemas in the same way as other objects via DB Explorer
• Domains added to the DB Explorer tree. Use Domain Editor to create and edit domains
• Grant Manager allows setting privileges for Databases, Functions, Schemas, and Languages
• Index list moved to the main tree, like triggers and rules, and the Index Editor window is no more modal
• German and Russian localizations added. Select the Options | Select Program Language main menu item to change the program interface language
• Grant Manager now allows setting privileges for the PUBLIC group
• Now you can select objects to expand automatically in the DB Explorer on connect to the database. Use the Tools | DB Explorer page of the Environment Options dialog for this purpose
• Fixed bug in connecting to a database, if it contains two objects in one name space with names differing only by their case
• Fixed bug in connecting to a database, if it contains views with spaces in their names
• A lot of other bug-fixes and small improvements

Scroll to top

 

 Version 1.1.0.1

 

• Now PostgreSQL Manager supports the PostgreSQL server v7.3!
• Function Editor: The 'Is Cachable' option is gone, the new option 'Execute with definer's privileges' and the new switch 'Replace multiple calls with single on same arguments' added
• Type Editor: Boxes 'External Length', 'Send Function' and 'Receive Function' disappeared
• Operator Editor: New fields 'Less Than Operator', 'Greater Than Operator' and 'Support merge joins' added
• Language Editor: The 'Validation Function' drop-down list appeared
• Options 'Is Cachable' and 'Is Strict' in Function Editor were renamed into 'Returns same result on same arguments' and 'Returns null on null input' respectively
• The array types, which names begin with '_' are excluded from the DB Explorer object tree
• Fixed bug with granting privileges to groups
• When 'Grant All' is performed in Grant Manager, the Owner privilege is not granted, as it was in previous versions
• No error message appears now if on saving an Index the 'Rollback' button is clicked
• Fixed an error with decreasing of the connection speed if the database contains rules and triggers and system objects are not displayed
• Several improvements and small bug-fixes

Scroll to top

 

 Version 1.0.0.1

 

• The 'Services' menu added. It contains powerful wizards for executing native PostgreSQL services: Analyze Tables, Vacuum Tables, and Reindex
• Service 'Analyze & Vacuum Table' is now available for each table. It can be called quickly from Table Editor
• Interface localization is implemented. No languages are available yet, but you can create your own language file to localize the PostgreSQL Manager interface. Just press Shift+Ctrl+L within any window to call Localization Editor or create your own *.lng file based on the 'english.lng' file (see $(PostgreSQL Manager)\Languages folder to find it). We will be very grateful to anyone who send us a translation of 'english.lng' to his native language (we will provide each translator with a free PostgreSQL Manager copy)
• The Design Query setting tab is added to the Environment Options window
• A possibility of running multiple PostgreSQL Manager instances added. The 'Disable multiple instances' option appeared in the Environment Options window on the Preferences tab
• The 'Show System Objects' option now applies to a database only, not to the whole application. This option is excluded from the Environment Options dialog and moved to the Register Database and Register Host dialogs
• The 'Sort By Aliases' element of the DB Explorer popup menu now saves its value after restarting the application
• The 'Confirm running selected query in Query Data' option is now excluded from the Environment Options dialog, the 'Execute selected text separately' option added to the Tools | Query Data tab instead
• Fixed bug in generating the SQL statement in the Create Database Wizard
• Several small improvements and minor bug-fixes

Scroll to top

 

 First public release

 

Basic features:

• Easy management of all database objects: creating/dropping databases, schemas; creating/dropping/altering tables and their subobjects, views, functions, sequences, rules, types, aggregates, operators, languages; etc.
• Creating/dropping/altering all the table subobjects
• Viewing/editing data in tables
• Support of all PostgreSQL data types
• Multiple database connections
• Powerful User Manager, Group Manager and Grant Manager
• Query Data with syntax highlight
• Visual Design Query
• Powerful BLOB Viewer/Editor that provides several ways of viewing BLOB data
• Export data to 12 popular formats, including MS Access, Excel, RTF (Word), HTML, etc.
• Import data from most popular formats, including MS Excel, Access, etc.
• Load Data to/from the server
• Customizable program interface
• Detailed Help System and User's Guide

and more...

Scroll to top

 

---