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"
Destination: PostgreSQL RDS
Drop the foreign key constraint on the table in the PostgreSQL warehouse.
Fivetran doesn't create a Foreign key constraint on the table for Postgres warehouse as it blocks from deleting a record from that table.