dbForge Studio for PostgreSQL History

3.1.839 17-Jan-24

User-reported and internal bug fixes

Fixed an error that occurs when switching between Card View and Grid View in the Data Editor

3.1.832 10-Jan-24

Schema Compare

New Alt + Up/Down Arrow shortcuts for navigating script differences in the lower comparison pane

User-reported and internal bug fixes

Several user reported minor bugs are fixed

3.1.789 27-Nov-23

Improvements

Upgraded from legacy chart designer to advanced new version
Added support for displaying trigger fire on SQL Profiler diagram
Added support for server sequences starting from PostgreSQL server version 9.1
Added support for event triggers in the Generate Script As functionality

User-reported and internal bug fixes

Resolved an issue with column name encoding in scripts generated for Redshift (D130582)
Fixed potential product crash on CrossOver during window animation processing (D134916)
Resolved SELECT query execution error occurring with edit mode activated in Data Editor (D119388, D120119, D120443)
Enhanced syntax checking to include support for the pgvector extension types (D138105, D127261)
Resolved the issue of quote duplication during data copying from Data Editor (D131873)
Fixed error encountered when trying to display the smart tag window (D133770, D138738)

3.1.701 18-Aug-23

User-reported and internal bug fixes

Fixed an error that occurred when parsing the bodies of scripts containing CREATE FUNCTION/PROCEDURE statements

3.1.696 16-Aug-23

Connectivity

Added support for PostgreSQL 16

User-reported and internal bug fixes

Fixed an issue with the quoting of case-sensitive names that occurred during the generation of a synchronization script (D120232)
Fixed an issue that occurred when expanding the Views node in Database Explorer (D123110)
Fixed an issue that occurred when expanding the database list in SQL Document (D127740)
Fixed the incorrect display of fonts that occurred when opening the Studio on Linux or macOS via CrossOver (D118342)
Fixed the incorrect display of the fractional part for the INTERVAL data type (D118190, D118202)
Fixed an issue with the Connection Manager (D123748)
Fixed an issue that occurred when exporting data containing floating-point numbers (D123443, D126756)

3.1.618 24-May-23

Connectivity

Added support for EDB BigAnimal
Added support for TLS 1.3
Added the ability to connect to the database server via SSH using SHA-256/512 algorithms
Added support for Aiven Cloud

Improvements

Optimized the process of retrieving the number of records in a table
Added the ability to save user-defined column layouts in Query History
Added a collection of new code snippets
Added new options for effective tab management
Added support for the UNLOGGED keyword in the CREATE UNLOGGED SEQUENCE command
Improved the behavior of the Disable DML trigger option

User-reported and internal bug fixes

Fixed an error that occurred when using a shared folder on the disk for query cache in Query History (D115047)
Improved the behavior of the Generate Script AS functionality for creating scripts with values as INSERT and UPDATE statements (D117929)
Added alphabetical sorting of triggers in the Database Explorer (D109264)
Fixed an error that occurred when generating the Quick Info tooltip (D117836)
Added the ability to configure formats for the Boolean data type in the Data Import wizard (D113260)
Fixed an issue with profiling parameterized queries (D118167)
Fixed an issue with processing tables containing columns of PostGIS data types (D115841, D117345, D114863, D113588, D113628, D113826, D114439, D114862)
Fixed the suggestions behavior on databases with foreign tables (D114505)
Fixed an issue with the suggestions generation in SQL editor (D113473)

3.0.472 30-Jan-23

General

Added support for Linux and macOS using CrossOver

Added new Professional Edition, which includes:

Data Compare
Schema Compare
Data Generator
Export of Query History to the CSV format
Command-line support for the following functionality: Data Compare, Schema Compare, Data Generator, Execute Large Scripts, as well as Data Export and Import

Text Editor enhancements

Added support for the SELECT INTO statement
Added suggestions for the names of non-aggregated columns in the GROUP BY clause
Added quick navigation between brackets
Added support for Ctrl+C/X/V hotkeys for coping/cutting entire line in SQL documents
Introduced a triple-click to select the entire line in SQL documents
Added support for RAISE [ NOTICE | WARNING | INFO ] to trace userscript messages in the Error List & Output windows
Added pop-up execution notifications
Added transaction reminders
Added capability to set quotes for identifiers when generating scripts
Added support for Amazon Redshift databases query profiling
Added the auto-refresh of local cache with an option to ignore selected databases

Other

Added connectivity support for PostgreSQL 15
Extended support for high-DPI devices
Improved the behavior of the Retrieve Data feature
Added connectivity support for AWS Babelfish
Added connectivity support for YugabyteDB
Added connectivity support for Neon.tech
Added connectivity support for Digitalocean Managed Databases
Added connectivity support for CitusData
Added connectivity support for ApsaraDB
Added connectivity support for PolarDB
Added connectivity support for AnalyticDB
Added connectivity support for Bit.io

User-reported and internal bug fixes

Fixed an error with an incorrect sequence of disabling restrictions that occurred during data synchronization (D48577)
Resolved an issue that occurred when importing data from a OneDrive spreadsheet (D65376, D92269)
Added support for query profiling on older versions of PostgreSQL (T318300)
Fixed an issue that took place while working with the trial version (T323376)
Fixed an error that occurred when connecting to a PostgreSQL database hosted on DigitalOcean (D51449)
Fixed an error that occurred when exporting data that contain accent marks (D72383)
Fixed the retrieval of high-precision floating-point numbers (D74191)
Fixed application freezing that occurred when getting data from a table with a TEXT column (D62033)
Fixed application freezing (D81773)
Fixed an error that occurred when opening the Start Page window (D84519, D84793, D88001)
Fixed an error that occurred on application launch (D93321)
Fixed an error that occurred when retrieving data for a 'scale' table (D85089)
Implemented shortcuts to switch between SQL Document tabs (D104137)
Resolved the Drag & Drop issue in Database Explorer (D99933)
Fixed a bug with the activation of the JSON tab for the JSON and JSONB data types when viewing data in Data Viewer (u33690838)
Fixed an error that occurred when retrieving data from array columns (D94900)
Added the Owner Use field for procedures and functions in the Properties window (D85062)
Fixed an error that occurred when establishing a server connection (D78820, D82508, D95889)
Improved data comparison performance in Data Compare (D77330)
Fixed comparison and synchronization of the RESTRICT, CASCADE, and NO ACTION values for foreign keys in Schema Compare (D74998)
Fixed Data Editor context menu (D68016)
Fixed metadata retrieval for Code Completion (D67261)
Improved Data Editor functionality (D50052)
Substituted the error that occurred when trying to access the pg_shadow schema in Schema Compare without proper rights with a warning (D69369)
Fixed an error that occurred when removing a connection from Database Explorer using the keyboard shortcuts (D67111, D75937)
Fixed an error that occurred when comparing the data types of procedure parameters (D65629)
Fixed the retrieval of database objects on older versions of PostgreSQL (D66474)
Extended the query execution error message with more detailed information (D62014)
Removed extra brackets in the generated view script (D101162)
Fixed an error that occurred when exporting data (D98600)
Fixed an error that occurred when importing data from Excel (D96902)
Fixed an error that occurred when using the DESCRIBE command in Schema Compare (D74998)
Fixed the Ignore Case option in Data Compare (D81596)
Resolved an issue with table columns comparison (D76561)
Added a possibility to make changes to a document connection after deleting a database (D73381)
Fixed an error that occurred when getting DDL of an inherited table
Fixed an error that occurred when opening a SQL document with query profiling results
Fixed the display of query execution time

2.3.287 22-Nov-22

User-reported and internal bug fixes

Fixed PostgreSQL connection issues (D103934, D103042)
Fixed several minor errors

2.3.285 15-Jul-22

User-reported and internal bug fixes

Fixed compatibility issues with the latest Windows 11 updates (D84717,D85016,D90557)

2.3.280 20-May-22

Improvements

Support for scram-sha-256 (D309923)

User-reported and internal bug fixes

Fixed a UI error (D69559, D82938, D85479, D85652)
Fixed an error that occurred when working with the editor in SQL document (D80951)
Fixed an issue with inserting items from a dropdown list (D81792)
Fixed a problem with establishing SSPI connection with the server (D85562)

2.3.278 20-Oct-21

New features

Connectivity support for PostgreSQL 14

User-reported and internal bug fixes

The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update

2.3.273 12-Aug-21

User-reported and internal bug fixes

Resolved an issue with generating DDL triggers to a script
Resolved an issue with opening a data report document (D62268, D62249)

2.3.268 29-Jul-21

User-reported and internal bug fixes

Fixed an issue that occurred when updating Data Editor with server-side sorting/filtering enabled (D55021)
Fixed an issue that could lead to freezing when executing a function (D59273)
Resolved an issue that led to SQL document losing focus after execution (D55786)
Fixed error report on typing in SQL document (D59275)
Fixed error report on closing SQL Document (D51575)
Resolved an issue with duplicating columns in Member List (D52937)
Fixed incorrect text replacing on inserting items from Member List (D53183)
Fixed false-negative syntax checking (D58703)
Fixed incorrect date format when exporting to Excel (D59970)

2.3.256 11-Mar-21

User-reported and internal bug fixes

The application may fail due to stack overflow error when working with specific queries (D50597, D50612)

2.3.255 25-Feb-21

User-reported and internal bug fixes

The database connection becomes unusable after executing a script with errors (T325239, D48850)
Some parts of the workbook require repairing when exporting data to the Excel 2007 format (T318267)
Possible critical error when trying to display the loading animation image in specific cases (T317898)
The program may fail with a critical error on closing the main window with open documents (T318952)
Possible failures when trying to gather quick info for specific code contexts (T319428)
When trying to generate DDL scripts for tables with previously dropped columns the program faces the fatal error (T324109)
Possible errors when trying to profile queries (T320450)
Incorrect code snippets behavior when composing scripts for creation of functions and procedures (T325785)
Possible failures when preparing data for the completion list (T320422)
In specific cases, the program may fail with the fatal error after opening SQL documents (T320856)
Trying to run specific queries may hang the client session (T324327)
The 'Unicode' option is not enabled by default for new connections (T325045, T325280)
Exporting data to plain text always adds leading whitespaces to the first column (D48683)
The incorrect quotation behavior when exporting to the CSV format (D48683)

2.3.244 28-Dec-20

Improvements

Work of the application when connecting via SSL is improved

User-reported and internal bug fixes

An issue with connecting to IBM Cloud via SSL (T303131, T320717, T319699)
An issue with processing Quick Info hints (T319058, T319156, T319659, T319691, T319693, T319988, T320235, T321077, T321261, T321490, T321776, T321918, T322315, T322671, T322705, T321466)
Error with data export from multiple tables (T321285)
Error with displaying data in FK LookUp editor (T320949)
Error with editing data when pressing Space (T317850)
The discrepancy between column type and data editor in it (T317850)
Treatment of the "REINDEX" keyword as an unexpected symbol (T318951)
An option to append a timestamp to a file name is enabled by default (T318267)
Error with closing SQL document (T320205, T321175)
Error with retrieving data from the compound types based on other compound types (T321077)
Displaying datatype in the header of Data Editor (T322960)

2.3.237 21-Sep-20

User-reported and internal bug fixes

The application could fail with a critical error when restoring documents from previous sessions (T316768, T317636)
An error occurred when trying to view indexes for the columns not available in the database explorer (T316956)
Incorrect scripts were generated for dropping functions (T316947)
The execution process for invalid scripts could hang (T317509)
The application could fail with a critical error when trying to display the quick info (T316765)
It was impossible to set the TIMESTAMP value to the current date and time Data Editor (T317507)
An error could occur during snippets storage initialization
A critical error could occur when launching Query Profiler

2.3.230 31-Aug-20

User-reported and internal bug fixes

The application failed with a critical error when pressing Backspace immediately after completing a table name (T315942)
An error occurred while exporting documents or data to '*.docx' format due to missing assembly (T315012)
Possible fatal error on filtering a completion list (T316045)
An error that could occur while filling table columns in a completion list (T316070)
The 'DROP OPERATOR' statement was treated as invalid syntax construction
Possible failure with a critical error when editing multi-line select script with opened completion list
The 'IF NOT EXIST' option was treated as invalid syntax when typed after 'ADD COLUMN' clause
The '[ AND [ NO ] CHAIN ]' options were treated as invalid for the 'ROLLBACK' statement

2.3.212 12-Aug-20

Script Generator Improvements

Generate Script as DROP and CREATE SEQUENCE
Generate Script as DROP and CREATE TABLE
Generate Script as DROP and CREATE for all Source Objects
Generate Script as CREATE INDEX

SQL Formatter Improvements

CREATE TRIGGER
CREATE INDEX
CREATE SEQUENCE
CREATE TABLE
CREATE VIEW
CREATE MATERIALIZED VIEW
CREATE PROCEDURE\FUNCTION

Query Profiler Improvements

Option to view query execution plan without running a query was added

User-reported and internal bug fixes

Fatal error caused by the absence of the 'Bezier' skin in the application preferences and which occurred when trying to save options when the skin was active (T293202, T302581, T304084)
Treatment of the "ILIKE" keyword as an unexpected symbol (T305684)
Incorrect formatting for TIMESTAMP values was fixed (T298357)
Critical error occurred when trying to paste empty values to integer fields (T308920)
The 'syntax error at or near ")"' error message displayed in specific cases when working with indexes (T309366)
Issue with possibly incorrect quotation handling leading to errors during syntax check and formatting (T308442)
Critical error occurred due to incorrect command availability handing when trying to copy from query results grid with row numbering enabled (T309718)
Possible unexpected server response errors (T311429, T306785, T312252)
Errors that might occur when formatting expressions from executable code fragments (T308582, T313109)
Possible errors when parsing complex scripts (T310955)
Critical error occurred when processing extremely large scripts containing the '$$' sequence
Critical error the application faced after closing the document in case its text has not been yet supplied

2.2.207 05-Dec-19

User reported bugs fixed

Problem with edit parameter window is fixed (T298233)
Problem with data import through Devart ODBC driver for Oracle is fixed (T298292)
Queries executing with custom parameters issue is fixed (T297883)
Problem with query profiling on 4K display is fixed (T297789)
Problems with data selecting from big tables are fixed (T297618, T297610)

2.2.198 12-Nov-19

User reported bugs fixed

Problem with Query Profiling Mode on High Definition displays is fixed (T297789)

2.2.197 07-Nov-19

User reported bugs fixed

Problem with query running when Query Profiling Mode is turned on is fixed (T293197)
Problem with aliases generating is fixed (T296186)
Problem with foreign key lookup when editing cell in data editor is fixed (T293995)
Problem with query parameters in sql document is fixed (T293611)
Problem with sql formatting when NOT EXISTS clause using is fixed (T293445)

2.2.184 01-Oct-19

New features

Connectivity support for PostgreSQL 12
Support for Amazon RedShift
Generate Script AS CREATE for Source Objects
SQL Code Formatter
Cached Update mode in Data Eidtor
Dramatically improved performance of Large Script Execution
New modern application skins

User reported bugs fixed

Problems with option Query Profiling Mode are fixed (T282537, T291096)
Problem with data view in data editor is fixed (T291144)
Problems with connectinig to server are fixed (T289975, T289283)
Problem with comments in script is fixed (T281868)
Problem with incorrect data in Quick Info is fixed (T284615)
Other user reported bugs are fixed (T282483, T262814, T293121)

2.1.97 06-May-19

New features

Connectivity Support for Greenplum DB
Query Profiler functionality

Improved features

Code Completion
Database Explorer
Execute Large Script wizard

User reported bugs fixed

Problem with connection to database is fixed (T273168)
Problem with highlighting keywords is fixed (T272218)
Problem with supporting unicode characters is fixed (T276532)
Problem with data importing from Excel is fixed (T274766)
Problem with editing connection category is fixed (T272243)
Problem with displaying databases is fixed (T252288)
Other user reported bugs are fixed (T247464, T271986, T271985, T277736)

2.0.111 10-Dec-2018

New features

Data Export&Import Wizard
Executed SQL Statements History
Execute Large Script Wizard
Master-Detail Browser
Pivot Table
SQL Snippets
Data Reports

SQL Document

Context prompt in the FROM list of the SELECT queries
Full code completion support for the SELECT statement

Connectivity

SSH connection
Connectivity support for PostgreSQL 11.x
Connectivity support for PostgreSQL 10.x
Connectivity support for PostgreSQL 8.3, 8.2, 8.1
Connectivity support for elephantsql.com

Other Improvements

Digital signature for the installation file
FIPS compliance
The Express Edition will be activated after Standard Edition trial expires

User reported bugs fixed

Empty field in "Find Result" issue is fixed (T262783)
Problems with object names in double quotes are fixed (T254981, T254663, T261473)
Ignore capitalization of tables issue is fixed (T252294)
Wrong navigation in "Find Results" issue is fixed (T262783)
Data editing after refresh issue is fixed (T249168)
Problem with look up using Foreign Key in data grid is fixed (T249168)
Wrong error output into "Error List" window issue is fixed (T267239)
Other user reported bugs are fixed (T265265, T262783, T262107, T266337, T246559, T248389, T247982, T249168, T249748, T257319, T256988, T257328, T257784, T257498, T258069, T252101, T248339, T252633, T258491, T244493)

1.0.410 05-Jun-2018

User reported bugs fixed

Problem with connection to PostgreSQL 10.4 is fixed (T258409)
Menu item "Retrieve Data" issues are fixed (T255318, T255332, T255583, T256624)
Problems with double click on a table in the database explorer tree are fixed (T255320, T255441, T255472, T255529, T255572, T255684, T255753, T256393, T256652, T257694, T257665, T257778, T257774, T257825, T257894, T258400, T258674, T258694, T258671)
Problem with expanding some index in the database explorer tree is fixed (T255319)
Null Reference Exception issue is fixed (T249168)
Problem with jsonb value is fixed (T249168)

1.0.381 24-Apr-2018

User reported bugs fixed

Wrong page after successfully installation issue is fixed (T254732)
Problems with database name are fixed (T254663, T254981)
Column value editing issue is fixed (T249168)
Execute script issue is fixed (T253087)
Problems with catalogs, temporary schemas and tables display are fixed (T251539, T247102)
Problem with incorrect format is fixed (T246966)

1.0.344 03-Mar-2018

First release of dbForge Studio for PostgreSQL