Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Whether the Selected Table Contains Delay Constraints
Updated on 2023-02-15 GMT+08:00
View PDF
Share

Whether the Selected Table Contains Delay Constraints

PostgreSQL Serving as the Source in Synchronization

Table 1 Whether the selected table contains delay constraints

Check Item

Whether the selected table contains delay constraints

Description

Tables that contain delay constraints may fail to be synchronized.

Failure Cause and Handling Suggestion

Failure cause: Tables that contain delay constraints may fail to be synchronized.

Handling suggestion: Remove the delay constraints.

  • SQL statement for deleting a constraint: 
    alter table Schema_name.Table_name drop CONSTRAINT Constraint_name
  • SQL statement for adding a constraint: 
    alter table Schema_name.Table_name add CONSTRAINT Constraint_name Constraint_type (Field list) NOT DEFERRABLE

Parent topic: Database Parameters