dbForge Schema Compare for PostgreSQL v1.5 release notes

Last modified: December 4, 2024

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 support for foreign key columns in ON DELETE SET NULL and ON DELETE SET DEFAULT clauses
• Added support for the comparison and synchronization of DML and event (DDL) triggers
• Improved the comparison and synchronization of UNIQUE constraints
• Added full support for the comparison and synchronization of CHECK constraints
• Implemented access to the automated generation of comparison reports directly from the Comparison Report wizard
• Added new customization options for the automated generation of comparison reports
• 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

• Fixed metadata retrieval that could fail on specific server versions (D163777, D163792)
• Fixed an issue with the display of privileges in schema comparison documents (D147530)
• Improved support for special values in datetime datatypes