dbForge Data Compare for PostgreSQL Revision History

2026.1.77 25-Jun-2026

User-reported bug fixes

Resolved clipboard data corruption when copying HTML data with duplicate column names

2026.1.39 15-May-2026

User-reported bug fixes

Several minor bugs are fixed

2026.1.31 11-May-2026

AI Assistant

Improved AI Assistant by adding support for database index metadata

Text Editor

Added the Enclose identifiers in quotes feature to the SQL Editor
Added syntax highlighting for PostgreSQL dollar-quoted blocks
Added index name suggestions in code completion
Added indexed column icons in Quick Info

Improvements

Added the ability to pin document tabs
Added the ability to restore document tab order

User-reported bug fixes

Fixed the behavior of the "SQL Look In" option in the Find and Replace control
Fixed a syntax error related to the FETCH FIRST clause
Added support for the dec (n, m) type in the PostgreSQL parser
Added support for multiple SELECT result sets and RAISE NOTICE output within a single session
Fixed an error in the data editor that occurred when executing a modified query before the previous query had finished fetching data
Improved saving of window layouts and restoration of window positions after restarting the Studio
Fixed the Find and Replace control to restore its settings after restart
Removed the automatic execution of ROLLBACK when closing a connection
Added support for the ANALYSE keyword in the EXPLAIN clause grammar
Extended parsing support for the CREATE INDEX expression syntax to include NULLS NOT DISTINCT
Updated the installation wizard to not display the "Successful Install" page during dbForge product updates

2025.3.149 25-Mar-26

User-reported bug fixes

Added support for the VARIADIC syntax for SQL Document

2025.3.107 12-Feb-26

User-reported bug fixes

Several minor bugs are fixed

2025.3.93 29-Jan-26

User-reported bug fixes

Several minor bugs are fixed

2025.3.61 24-Dec-25

Text Editor Improvements

Added scroll bar annotations
Added an option to automatically surround selections
Improved code completion in routines to recognize local variables and parameters inside stored procedure and function bodies
Added editor support for SELECT statements
Added editor support for INSERT, UPDATE, and DELETE statements
Added editor support for the WITH clause
Added editor support for the MERGE statement
Improved code completion to support named parameters
Added camelCase formatting for identifiers

User-reported bug fixes

Implemented a text preview for CLOB data types instead of an icon
Fixed an issue where floating-point values lost precision when copied to Excel
Fixed an issue with comparing databases that contain special characters in their names

2025.2.138 20-Nov-25

User-reported bug fixes

Several minor bugs are fixed

2025.2.109 31-Oct-25

User-reported bug fixes

Resolved an issue with handling NUMERIC values less than 0.0001
Resolved an issue with displaying the tooltip for a document bookmark, where the tooltip window overlapped the document bookmark

2025.2.91 23-Oct-25

User-reported bug fixes

Fixed a memory leak when executing queries in the SQL Document

2025.2.37 23-Sep-25

AI Assistant

Introduced automatic error submission from the Error List to AI chat for detailed explanations and suggested fixes
Added a Web Search option in the AI Assistant chat, allowing searches across Devart documentation, website, and blog

Improvements

Improved encryption capabilities
Added tooltips to the SQL document tab, showing connection and database names, document owner, full file path, and server version
Introduced the ability to customize the position where new document tabs open
Added Alt+Up and Alt+Down shortcuts to move selected lines up or down in the SQL document
Added the Ctrl+Shift+A shortcut to select the entire statement in the SQL document, including all related keywords, operators, and values

User-reported bug fixes

Added support for NaN values in the numeric data type in Data Editor(#174320, #178246)
Fixed an issue with the truncation of numeric values in Data Editor
Removed the call to pg_backend_pid() between the START TRANSACTION and SET TRANSACTION commands
Introduced caret position persistence upon document reload

2025.1.230 21-Aug-25

User-reported bug fixes

Fixed time format mismatches between the same data in the view and edit modes

2025.1.186 21-Jul-25

User-reported bug fixes

Fixed an issue with the data format for the range of timestamp with time zone type in the synchronization script (#204357)
Fixed an issue with the automatic display of Data Editor: when the Activate Data Editor after query execution option is enabled, Data Editor now opens automatically after a query runs, even if no data is returned
Fixed an issue with long file names
Removed opening the connection on the main thread when opening the parameter input form

2025.1.134 23-Jun-25

User-reported bug fixes

Added support for parsing geometric arrays with schema specification

2025.1.124 16-Jun-25

AI Assistant is added

Context-aware query generation
Conversion of natural language to SQL
Query optimization
SQL explanations
SQL troubleshooting
Error analysis and recommendations
AI chat
Integration with the dbForge tools

Connectivity

Added support for PostgreSQL 18

Improvements

Updated color palettes for the Light and Dark skins
Refined font rendering and the coloring of syntax errors
Added Brief View to the Start Page to switch between displaying full paths to recent files and a more compact list

User-reported bug fixes

Resolved incorrect parsing of geometry types with dimensions that caused the affected columns to not appear in Database Explorer (#201920)

4.2.126 03-Mar-25

User-reported and internal bug fixes

Fixed an error that occurred when using 'plpgsql' in lowercase within an anonymous code block
Resolved an issue with editing data in tables containing a SERIAL column in Data Editor

4.2.47 03-Dec-24

Connectivity

Added support for PostgreSQL 17
Added support for AlloyDB
Added support for Supabase
Added support for Google Cloud
Added support for Azure Cosmos DB for PostgreSQL
Added support for the rds-ca-rsa2048-g1 SSL/TLS certificate for connecting to PostgreSQL servers on Amazon Web Services

Text Editor

Added parameter info and quick info for functions and procedures
Added suggestions for foreign key columns in ON DELETE SET NULL and ON DELETE SET DEFAULT clauses
Added suggestions for columns declared in scripts for foreign keys within CREATE TABLE and ALTER TABLE clauses
Added suggestions for existing triggers, ENABLE REPLICA, ENABLE ALWAYS, and potential owners in ALTER EVENT TRIGGER clauses
Added suggestions for existing triggers in DROP EVENT TRIGGER clauses
Added suggestions for CREATE OR REPLACE, FOR EACH ROW, FOR EACH STATEMENT, DEFERRABLE INITIALLY DEFERRED, and DEFERRABLE INITIALLY IMMEDIATE in CREATE TRIGGER clauses
Added suggestions for triggers along with the tables and views they are based on in ALTER TRIGGER clauses
Redesigned Query History, whose toolbar now includes an updated range selection and a button that clears the history
Added the ability to duplicate, remove, and join current lines in SQL documents using shortcuts

Improvements

Added new customization options for the automated generation of comparison reports
Implemented access to the automated generation of comparison reports directly from the Comparison Report wizard
Implemented an option that sets the value of a cell to a unique identifier from the Data Editor context menu

User-reported and internal bug fixes

Added support for ON UPDATE CASCADE and ON DELETE CASCADE clauses to be applied during the re-creation of foreign keys for data synchronization

4.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

4.1.832 10-Jan-24

User-reported and internal bug fixes

Several user reported minor bugs are fixed

4.1.789 27-Nov-23

User-reported and internal bug fixes

Fixed potential product crash on CrossOver during window animation processing
Resolved SELECT query execution error occurring with edit mode activated in Data Editor

4.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

4.1.696 16-Aug-23

Connectivity

Added support for PostgreSQL 16

User-reported and internal bug fixes

Fixed an issue in Data Compare that occurred when comparing tables that have indexes but don't have primary keys (#121639)

4.1.618 24-May-23

Connectivity

Added connectivity 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

Added new options for effective tab management
Improved the behavior of the Disable DML trigger option

User-reported and internal bug fixes

Fixed an issue with comparing and synchronizing columns of GEOMETRY type (#116277)
Fixed an error that occurred when generating a data synchronization script for the TIMESTAMP data type (#111158, #114591)

4.0.472 30-Jan-23

General

Added support for Linux and macOS using CrossOver

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 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 the auto-refresh of local cache with an option to ignore selected databases

Other

Extended support for high-DPI devices
Added connectivity support for PostgreSQL 15
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 (#48577)
Fixed an error that occurred when connecting to a PostgreSQL database hosted on DigitalOcean (#51449)
Improved data comparison performance (#77330)
Fixed the Ignore Case option (#81596)

3.4.14 22-Nov-22

User-reported and internal bug fixes

Fixed a PostgreSQL connection issue (#101016)
Fixed several minor errors

3.4.13 22-Oct-21

Improvement

Connectivity support for PostgreSQL 14 is added

3.4.7 26-Aug-21

New features and improvements

Connection to IBM Cloud using SSL
Connection to Amazon Aurora
Support for SSH connection to the server

User-reported and internal bug fixes

Formatting of invalid synchronization script (#51576)
Incorrect representation and comparison of the TIMESTAMP limit value (p178022)

3.3.9 11-Mar-21

User-reported and internal bug fixes

Syntax error occurred in the synchronization script in the 'Disable DML triggers' and 'Disable check constraints' blocks (T325319)
Unexpected exception occurred when objects were described during mapping (T322616)

3.3.6 31-Aug-20

New features and improvements

Connectivity support for PostgreSQL v.13
Option to add pre/post scripts (Additional Scripts) to the Data Compare
Support for scram-sha-256 for password hashing and authentication

User-reported and internal bug fixes

Bug with selection mode checkbox (T313675)
An issue with connecting to a PostgreSQL server (T308333, T292810)
Other bug fixes and some improvements

3.2.15 08-Nov-19

Improvement

Connectivity support for PostgreSQL 12 is added

User reported bug is fixed

Problem with apostrophe in JSON is fixed (T286086)

3.1.11 26-Apr-19

User reported bugs are fixed

Problem with quotes inside JSON is fixed (T274686)
Problem with application reactivation is fixed (T279255)

3.1.7 29-Oct-18

Improvements

Connectivity support for PostgreSQL 10/11 is added (T243895, T245598, T246440, T248447, T266727, T267097)
Other user reported bugs are fixed

3.0.24 10-Oct-17

User reported bugs are fixed

User reported connection issues are fixed (T226349)
Known comparison issues with Amazon Redshift are fixed
Other user reported bugs are fixed

3.0.19 27-Sep-17

Improvements

PostgreSQL 9.6.5 is supported
Azure for PostgreSQL is supported
Types compatibility matrix extended
Advanced support for Range, PostGIS and Domain data types
Advanced support for Interval data type
Advanced support for JSON and JSONB data types
Command-Line Master which greatly simplifies creation of the command line execution files

2.0.59 29-Mar-17

User reported bug is fixed

User reported issue with activation status lost is fixed

2.0.49 07-Mar-17

User reported bugs are fixed

Known product activation issues are fixed

2.0.38 27-Jan-17

Improvements

PowerShell support is implemented
Other user reported bugs are fixed

2.0.6 21-Dec-16

Improvements

Support for PostgreSQL 9.5, 9.6 and Amazon Redshift is added
Comparison document has been completely redesigned
New JSON View and redesigned XML view in Data Editor and Viewer window
Categories for documents from different connections can be assigned now
New installation wizard and redesigned skins
New easy to use trial product activation

1.0.123 09-Oct-13

User reported bug is fixed

The application operating problem related to the case when Microsoft .NET Framework 4.0 is installed and Microsoft .NET Framework 3.5 is not installed is fixed (R26877)

1.0.114 05-Sep-13

User reported bug is fixed

The error on custom query comparison is fixed (R26070)

1.0.113 15-Aug-13

User reported bug is fixed

Error on database objects access is fixed (T75918, R25415)

1.0.110 13-Jun-13

Improvement

Product documentation is added

1.0.102 05-Apr-13

User reported bugs are fixed

Invalid name syntax on comparing data is fixed (R16504)
OutOfMemoryException on comparing data is fixed (R16218, R15378)
Performance on comparing LOB data is improved (R15710)
Inability to cancel data comparison is fixed (R15618)
FormatException on executing a script with parameters is fixed (R16473)
Columns with the UUID data type can be used as a comparison key now (T18076)

1.0.92 20-Dec-12

First release of dbForge Data Compare for PostgreSQL