dbForge Schema Compare for PostgreSQL Revision History

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

  • Fixed an issue that occurred when comparing string-type columns in PostgreSQL; COLLATE attribute comparison is temporarily disabled until full support is implemented (#219988)

2025.3.93 29-Jan-26

User-reported bug fixes

  • Resolved an issue that caused identical Amazon Redshift tables to be treated as different (#219988)

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

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

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

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

  • Resolved an issue with displaying script differences that occurred when Word Wrap was enabled
  • Added support for NaN values in the numeric data type in Data Editor
  • 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 the comparison and synchronization of arrays (#206187)

      2025.1.186 21-Jul-25

      User-reported bug fixes

      • 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

      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

      • Several user reported minor bugs are fixed

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

      1.5.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 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 (#163777, #163792)
      • Fixed an issue with the display of privileges in schema comparison documents (#147530)
      • Improved support for special values in datetime datatypes

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

      1.4.832 10-Jan-24

      Improvement

      • 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

      1.4.789 27-Nov-23

      User-reported and internal bug fixes

      • Added support for server sequences starting from PostgreSQL server version 9.1 (#128970)

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

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

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

      User-reported and internal bug fixes

      • Fixed the comparison and synchronization of functions that return a table (#116719)
      • Fixed an issue with describing stored procedures on RedShift (#115627, p217827)
      • Fixed an error that occurred when comparing CHECK constraints (#117932)
      • Fixed unexpected behavior that caused an invalid comment to be generated for a column (#113130)
      • Fixed an issue with processing tables containing columns of PostGIS data types (#112008, #113077, #114900, #115309, #115322, #115486, #120984)

      1.3.472 30-Jan-23

      General

      • Added support for SERIAL datatypes
      • Added support DEFAULT for function parameters
      • Added support for Sequences
      • Added option Show Ignored Differences
      • Added possibility to select database in comparison wizard

      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

      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 comparison and synchronization of the RESTRICT, CASCADE, and NO ACTION values for foreign keys (#74998)
      • Substituted the error that occurred when trying to access the pg_shadow schema without proper rights with a warning (#69369)
      • Fixed an error that occurred when comparing the data types of procedure parameters (#65629)
      • Fixed the retrieval of database objects on older versions of PostgreSQL (#66474)
      • Fixed an error that occurred when using the DESCRIBE command (#74998)
      • Resolved an issue with table columns comparison (#76561)

      1.2.211 22-Nov-22

      User-reported and internal bug fixes

      • Fixed PostgreSQL connection issues (#77328, #96831)
      • Fixed several minor errors

      1.2.182 07-Oct-21

      User-reported bug fixes

      • Fixed an issue with the loss of procedure and parameter name quoting (#65023)
      • Fixed an issue with the detection of differences in table-valued functions (#65023)
      • Improved behavior of the synchronization of procedures and functions using CREATE OR REPLACE (#65023)
      • Improved mapping behavior for overloaded procedures and functions (#65023)
      • Fixed an error that occurred when connecting via the SSH protocol (#66437)
      • Fixed an error that occurred when loading the application cache file (#65159)

      1.2.124 29-Jul-21

      New features and improvements

      • Improved Text Compare Control
      • Comparison Reports
      • Additional Scripts tab added to the Schema Comparison wizard
      • Support for materialized views comparison and synchronization in Amazon Redshift
      • Connectivity Support to Heroku Cloud
      • Object Filter

      User-reported bug fixes

      • Fixed an issue occurred when reading user metadata for servers below v9.5 (T317370, T325155, T317578, T320254, #54349)
      • Fixed a bug in the FOREIGN KEY script for Redshift (p178147)
      • Fixed an error occurred when working with the IDENTITY column (p178147)
      • Fixed an error occurred when working with function parameters during the comparison (T322066, T322479)
      • Resolved an issue with getting the table columns metadata (T319194, T319498, T319794, T320733, T320734, T324702, T325050, T325078, T322196, T324583, T323063, T325212, #50118, #52748, T32219648, T3250450 T323063, T324583, T325078, T322196, T324583, T323063, T325212, #58578, #52748, #55959)

      1.1.1 23-Nov-20

      New features and improvements

      • Connectivity support for PostgreSQL v.13

      1.0.52 03-Sep-20

      First release of dbForge Schema Compare for PostrgeSQL

      • Support for Amazon Redshift schema comparison and sync
      • Basic support for comparing PostgreSQL schemas with Amazon Redshift schemas