PostgreSQL Component Release Notes

This page lists the main features added to the PostgreSQL Component.

Change Log

DI-9076: Added support for XML field types in database metadata and integration flows.

DI-4676: The Create indexes on Target Table parameter has been added to the INTEGRATION PostgreSQL template.
DI-6256: Target filters have been added to the INTEGRATION PostgreSQL template.

DI-5505: When using the INTEGRATION Postgres template, data is unexpectedly inserted twice in the work table when it is in slowly changing dimension (SCD) mode.
DI-6285 & DI-6748: PostgreSQL - Driver upgrade.

DI-1947: PostgreSQL Component: fix creation mask for BIT datatype which was not taking into account the size defined and CHARCATER VARYING datatype which should ignore sizes greater than 1000

DI-1782: Addition a new datatype "Json" in PostgreSQL Metadata
DI-1889: Integration PostgreSQL - When the option "Create target table" is enabled, generated table creation statement now also contains the primary key defined in Metadata
DI-1890: INTEGRATION PostgreSQL - Add support for xpath expressions in deleteWhereClause parameter
DI-1910: Templates updated - New parameter 'Cdc Subscriber' on Templates on which it was not handled yet
DI-1909: Templates updated - New Parameters 'Unlock Cdc Table' and 'Lock Cdc Table' to configure the behaviour of CDC tables locking

DI-1908: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates on Lock / Unlock CDC steps
DI-1907: Templates updated - The 'Cdc Subscriber' parameter was ignored in some Templates when querying the source data

DI-2747: Template - LOAD Rdbms to PostgreSql (with COPY) - generated temporary file names may unexpectedly contain object delimiters

DI-3871: Template - Load Rdbms to PostgreSQL (with COPY) - clarify "Enable File Transport" parameter description

DI-2641: Reverse-engineer foreign keys referencing tables in another schema when the other table and schema are available in the metadata
DI-2656: PostgreSQL technology includes the list of database-reserved keywords
DI-4508: Update Components and Designer to take into account dedicated license permissions
DI-4962: Improved component dependencies and requirements management

DI-5319 : Update the PostgreSQL JDBC Driver proposed in the optional third-party pack to version 42.3.3.

DI-5505 : Template - INTEGRATION Postgres - The data is unexpectedly inserted twice in the work table when being in slowly changing dimension (SCD) mode.