dbForge Data Compare for PostgreSQL v4.2 release notes

Last modified: June 23, 2025

Connectivity improvements

• 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 enhancements

• 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

Other 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