dbForge Data Compare for PostgreSQL v4.2 release notes

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

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

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

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