View Revisions: Issue #6882

Summary 0006882: Capture TRUNCATE table events in PostgreSQL database
Revision 2025-07-02 13:29 by pbelov
Steps To Reproduce Set up a node with PostgreSQL database as a source.
Set the new start-up parameter
postgres.trigger.capture.truncate.event=true
(the trigger.capture.ddl.changes=true is optional in this case)

Create a test table :
   CREATE TABLE demo_small(id int);

Configure new SymmetricDS trigger for the demo_small table.

Execute truncate statement:
   TRUNCATE TABLE demo_small;

Observe: New sym_data records for the Truncate TAble event.
Revision 2025-05-09 18:39 by pbelov
Steps To Reproduce Set up a node with PostgreSQL database as a source.
Set the parameter
trigger.capture.ddl.changes=true

Create a test table :
   CREATE TABLE demo_small(id int);

Configure new SymmetricDS trigger for the demo_small table.

Execute truncate statement:
   TRUNCATE TABLE demo_small;

Observe: No new sym_data records.
Revision 2025-05-09 18:18 by pbelov
Steps To Reproduce