Issue

A connector running on Postgres RDS Warehouse fails with the following error :

ERROR: update or delete on table "x" violates foreign key constraint "y" on table "x"

Environment

Destination: PostgreSQL RDS

Resolution

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.