PostgreSQL Component Release Notes

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

Change Log

Version 2023.2.0

Feature improvements

  • DI-6928: New template: DESERIALIZER PostgreSQL String as JSON.

Version 2023.1.18

Bug fixes

  • DI-9617: Optimized the queries for CDC Data View and CDC Lock View to speed up reads from CDC tables.

Version 2023.1.15

Bug fixes

  • DI-9481: Implemented recognition of PostgreSQL UUID data types.

Version 2023.1.12

Bug fixes

  • DI-9528: Updated the PostgreSQL JDBC driver.

Version 2023.1.10

Feature improvements

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

Version 2023.1.2

Bug fixes

  • DI-7308: Driver upgrade: PostgreSQL

Version 2023.1.0

Feature improvements

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

Bug fixes

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

Version 19.0.25 (Designer)

Bug fixes

  • 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

Version 2.0.2 (PostgreSQL Component)

Feature improvements

  • 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

Bug fixes

  • 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

Version 2.0.3 (PostgreSQL Component)

Feature improvements

  • DI-2663: PostgreSQL Metadata - support jsonb datatype

Bug fixes

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

Version 2.0.4 (PostgreSQL Component)

Bug fixes

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

Version 3.0.0 (Component Pack)

Feature improvements

  • 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

Version 3.0.2 (Component Pack)

Feature improvements

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

Version 5.3.4 (Component Pack)

Bug fixes

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