Checking Whether There Are Enabled Triggers in an Existing Destination Database Table
GaussDB Serving as the Destination in Synchronization
Check Item |
Checking whether there are enabled triggers in an existing destination database table |
---|---|
Description |
An existing table in the destination database contains valid triggers, which may cause data synchronization task failures. |
Failure Cause and Handling Suggestion |
Failure Cause: An existing table in the destination database contains valid triggers, which may cause data synchronization task failures. Handling Suggestion: Use either of the following methods: 1. Disable triggers. alter table table_name disable trigger all; 2. Set the session parameter. set session_replication_role to replica; |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.