SQL Manager Lite for PostgreSQL Changelog

What's new in SQL Manager Lite for PostgreSQL 6.4.2 Build 56477

Mar 28, 2023

Improvements in PostgreSQL 15 support.
Improved support of dark schema for interface.
Support for LANGUAGE SQL body for functions.
FK links can be optionally hidden in Design Query editor now.
Templates for backup and restore are now saved in Unicode format.
Improved performance in Server Log Viewer.
Export of images as SQL Script now works correctly.
Filter window for data grid is resizable now.
Resizing of Database Designer editor works better now.
The list of visible columns was reset on switching to Card view. Fixed now.
Other improvements and fixes.

New in SQL Manager Lite for PostgreSQL 6.4.1 Build 56163 (Nov 14, 2022)

New in SQL Manager Lite for PostgreSQL 6.3.1 Build 54838 (Jul 26, 2021)

New in SQL Manager Lite for PostgreSQL 6.0.1 Build 53431 (Jan 29, 2020)

New in SQL Manager Lite for PostgreSQL 6.0.0 Build 53231 (Nov 1, 2019)

New in SQL Manager Lite for PostgreSQL 5.9.5 Build 52424 (Mar 19, 2019)

New in SQL Manager Lite for PostgreSQL 5.9.3 (Jul 27, 2018)

New in SQL Manager Lite for PostgreSQL 5.9.2 Build 50807 (Feb 22, 2018)

New in SQL Manager Lite for PostgreSQL 5.5.0 Build 44841 (Oct 6, 2014)

Added support of new PostgreSQL 9.4 features:
Support of JSONB data type
Support of changing foreign key deferability parameters without recreating the key
Support of moving all objects from one tablespace to another
Extract Database. Now the result script is correctly organized according to objects dependencies.
Backup Database. Now it is possible to add the current date and time to the result dump file name.
Change Management. Added support of the Slik Subversion 1.8.x client (SQL Manager works with 32-bit client version only).
SQL Editor. Code Completion. The PostgreSQL keywords is updated considering the last server versions.
Table Editor. Reorder Fields. Now the trigger is created after the data insert in the change script.
SQL Editor. Now if the ‘Don’t save queries automatically for the next session’ option is enabled, the user is warned that the changes are not saved automatically on closing the SQL Editor tab.
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.
SQL Editor. Query Plan. Now the numerical values are right-aligned and are splitted by orders.
DB Explorer. Now the Search field is not emptied when the search is finished.
Backup Database. The long operation log was cut at the end. Fixed now.
Function DDL. Illegal characters for unquoted identifiers were quoted incorrectly in parameters names. Fixed now.
Data Export. When exporting to the DBF file values of integer fields appeared in the result file with a thousand separator. Fixed now.
The wrong script generated on renaming fields of a view in a non-default schema. Fixed now.
Sometimes error occurred on changing a field type to smallserial. Fixed now.
Function Debugger. It was impossible to change the variable value of the time type.
Large number of other improvements and bug fixes.

New in SQL Manager Lite for PostgreSQL 5.4.0 Build 42379 (Oct 15, 2013)

New in SQL Manager Lite for PostgreSQL 5.3.0.1 (Apr 9, 2013)

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, Visual Database Designer diagrams, etc.
Database Registration Info dialog. Added the possibility to set PostgreSQL parameter values for a session.
Grant Manager. Added the possibility to extract grants as SQL script.
Fuction 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.
SQL Editor:
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.
Restore Database wizard. Now it correctly works with very large SQL files.
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.
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.
Editor Options. The background color settings were applied to object description fields, but foreground color settings were not. Fixed now.
Visual 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.
View Editor. After a trigger was modified, the information on the Triggers tab was not updated. Fixed now.
Search in Metadata. Searches are not performed in temporary objects now.
In the Floating windows environment mode the Windows Taskbar appeared upon launching the program, even it was hidden in the previous session. Fixed now.
Create Report wizard. The selected report style could not be applied to the report. Fixed now.
Dependency Tree. The dependence between parent and inherited tables could not be shown in the subobject display mode.
New Table form. When pressing Ctrl + Insert the Add filed dialog popped up, even if there was another active tab. Fixed now.
Many other improvements and bugfixes.

New in SQL Manager Lite for PostgreSQL 5.1 (Jul 2, 2012)

Added support of new PostgreSQL 9.1 features:
Support of collations.
Support of extensions (the Database Extensions tool in the Services main menu).
Support of view triggers.
Support of ALTER TYPE command for composite and ENUM types.
Support of unlogged tables.
Backup Database wizard. Added the support of backups creation for PostgreSQL 9.1.
Added the support of the column list for UPDATE triggers (PostgreSQL 9.0 and higher).
Function debugger. Added the possibility to debug trigger functions.
Function Editor:
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 the BIGINT parameter, 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 displayed in the code completion list. Fixed now.
Trigger Editor. Added the Ctrl+H shortcut to hide/display the trigger caption controls.
Change Management. Added the support of Slik Subversion client. Also the support of CollabNet Subversion сlient for Subversion is added.
Added the possibility to export table data into the file in many tools.
Check Constraint Editor. Added the possibility to set comments for constraints.
Foreign Key Editor. Now the form size can be changed.
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.
Data Grid.
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.
SQL Editor:
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 for adding a new query tab did not work. Fixed now.
When using the Azeri (Latin) locale some characters were 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 values input dialogue appeared. Fixed now.
Visual Database Designer;
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 working area became inactive, it did not respond to mouse clicks and did not allow adding a table. Fixed now.
Query Builder;
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.
Function debugger:
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 when 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.
Server Status:
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.
View Editor. The Dependency tab. In some cases not all dependencies were shown. Fixed now.
Extract Database. In server version 8.2 and higher, in some cases the CREATE SEQUENCE statement followed the CREATE TABLE statement that used this sequence. Fixed now.
Export as SQL script. When creating a non-PostgreSQL script, the INSERT statements were generated with errors. Fixed now.
Create Table form. If the “Unique” option was specified for the filed, while saving the table this option was not included in the script and was not saved. Fixed now.
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 saving, an AV error occurred. Fixed now.
Restore Database wizard. When restoring an SQL file with the CONNECT statement, an error occurred. Fixed now.
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.
Grant Manager;
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, whose name was a substring of another rolename, the cumulative rights of these two roles were shown. Fixed now.
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.
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.
Print Metadata. The page size in the template for A4 tables was incorrect. Fixed now.
SQL Script. The type and object names of some SQL statements were determined incorrectly for being displayed in the Statements explorer.
Vacuum Tables and Analyze Tables wizards. Even when selecting separate tables, the action was performed on all tables in the database. Fixed now.
Other small improvements and bugfixes.

New in SQL Manager Lite for PostgreSQL 5.0 (Jul 2, 2012)

New in SQL Manager Lite for PostgreSQL 4.8.0.0 (Nov 18, 2010)

New in SQL Manager Lite for PostgreSQL 4.7.0.0 (Feb 18, 2010)

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.
SQL Editor.
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.
Visual 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.
Query Builder.
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 small improvements and bugfixes.

New in SQL Manager Lite for PostgreSQL 4.6.0.1 (Sep 11, 2009)

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 (the options are added to the Backup and Restore Database wizards).
Sequence’s start value.
SQL Editor.
Using macro is now possible.
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 utility used to cut the filename. Now it cuts the file location.
When a query returned the Infinity value to a timestamp filed, the utility used to display this value as Null. Fixed now.
Data View.
When viewing table data, BLOB data are now loaded from server only when accessing them.
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 utility 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 is 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 a code fragment and an error position pointer.
Grant Manager. When granting rights to a table with the SERIAL field, the utility now suggests granting rights to the corresponding sequence.
SQL Script. If a file name and location were too long for the window title, the utility 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 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 connects 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 mode.
Other small improvements and bugfixes.

New in SQL Manager Lite for PostgreSQL 4.5.0.1 (May 28, 2009)

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 in the Grid | Data Options section of the Environment Options dialog will be applied as default settings for newly registered databases
The "Schema-organized database tree" option is added. Disabling this option results in creating the object tree without schema division.
Metadata and SQL Editor logs can now be saved in UNICODE or ANSI
Query Builder:
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 was improved
The button for switching the search mode is added to the 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 it is started next time, this database will be automatically selected in the DB Explorer tree
Double-clicking the object group folds or unfolds it
Visual 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 couldn’t print field and table icons. Fixed now
Data View | Blob View: The XML tab allowing you to view BLOB field values as XML is added
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
SQL Editor: Creation of queries with identical names was allowed. Fixed now
Code Parameters:
Code parameters weren’t 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
SQL Editor:
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 character “”. Fixed now
Other minor improvements and bug-fixes