0006990: Detect when PostgreSQL version supports CreateOrReplace command and set dbInfo.TriggersCreateOrReplaceSupported property - SymmetricDS

Summary	0006990: Detect when PostgreSQL version supports CreateOrReplace command and set dbInfo.TriggersCreateOrReplaceSupported property

Revision	2025-07-09 17:18 by pbelov
Description	In the Postgres DDL Builder, we should set the setTriggersCreateOrReplaceSupported(true) property so that we don't have to drop the triggers first before creating the trigger using the CREATE OR REPLACE construct. This is only applicable to PostgreSQL version 14 and later! Platform has the major and minor version numbers when building the DDL builder.

Revision	2025-07-09 17:15 by pmarzullo
Description	In the Postgres DDL Builder, we should set the setTriggersCreateOrReplaceSupported(true) property so that we don't have to drop the triggers first before creating the trigger using the CREATE OR REPLACE construct. This is only applicable for version 14 and later. Platform has the major and minor version numbers when building the DDL builder.