Question
Connector running on Postgres RDS Warehouse failing with error :
ERROR: update or delete on table "x" violates foreign key constraint "y" on table "x"
Environment
Destination: PostgreSQL RDS
Answer
Drop the foreign key constraint on the table in the PostgreSQL warehouse.
Cause
Fivetran doesn't create a Foreign key constraint on the table for Postgres warehouse as it blocks from deleting a record from that table.