PostgreSQL Component Release Notes

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

Feature Highlights

Version 2.0.4

Fixed issues

This version contains some fixed issues which can be found in the complete changelog.

Version 2.0.3

Minor improvements and fixed issues

This version contains some minor improvements and fixed issues, which can be found in the complete changelog. Complete changelog

Version 2.0.2

INTEGRATION PostgreSQL Template

Support XPath expressions in "Deletion Where Clause" parameter

"Deletion Where Clause" parameter now supports using XPath expressions.

This allows to generate dynamic expressions which uses some information retrieved from Metadata, for example.

Support automatic creation of primary key when creating target table

When using "Create target table" parameter to automatically create the target table during execution, the generated creation statement now also includes the primary keys defined in Metadata.

PostgreSQL datatype

Addition a new type of column "json", existing in PostgreSQL since V9.2.

Change Data Capture (CDC)

Multiple improvements have been performed to homogenize the usage of Change Data Capture (CDC) in various Components.

Parameters have been homogenized, so that all Templates should now have the same CDC Parameters, with the same support of features.

Multiple fixes have also been performed to correct CDC issues. Refer to the changelog for the exact list of changes.

Version 2.0.1

INTEGRATION PostgreSQL

Fix issue with index name

When delimiters were required on the temporary table, an incorrect index name was generated.

Fix issue with CDC unlock step

CDC unlock step had a wrong generation condition which avoided it to be executed.

Fix creation mask

A column with "bit" datatype did not take into account the set size.

A data type field "varchar" or "character variant" has a maximum size of 1000. When a larger size was set, it was incorrectly handled.

Change Log

Version 2023.1.20

Bug fixes

  • DI-6666: Fixed VARCHAR fields to allow sizes over 1000 characters.

Version 2023.1.19

Feature improvements

  • DI-10325: Updated internal labels in mappings so Semarchy xDG can correctly capture asset names and compute siblings.

Bug fixes

  • DI-9483: Fixed the default size for UUID-type fields.

  • DI-10150: Template INTEGRATION Rdbms: corrected the template’s behavior so it avoids trying to create indexes on tables that already have one, which causes processes to fail.

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 (PostgreSQL Component)

Bug fixes

  • DI-7308: Driver upgrade: PostgreSQL

Version 2023.1.0 (PostgreSQL Component)

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.