Edit on GitHub
Error: Update or Delete on Table Violates Foreign Key Constraintlink
Issuelink
A connector running on a PostgreSQL RDS destination fails with the following error:
ERROR: update or delete on table "x" violates foreign key constraint "y" on table "x"
.
Environmentlink
Resolutionlink
Drop the foreign key constraint on the table in the PostgreSQL destination.
Causelink
Fivetran doesn't create a foreign key constraint on a table because PostgreSQL doesn't allow the deletion of records from a table that contains a foreign key.