View Revisions: Issue #6990

Summary 0006990: Postgres databaseinfo should set setTriggersCreateOrReplaceSupported(true) property
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.
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
Additional Information
Revision 2025-07-09 17:18 by pbelov
Additional Information Sourceforge report: https://sourceforge.net/p/symmetricds/discussion/739237/thread/bc2f456bc7/