We support users who have tables in Postgres without primary keys.

Rather than do a full sync, Fivetran constantly appends changes to destination tables.

This results in tables that have one row in the origin to have multiple rows in the destination after any change/s.

This leads to records that the user can only see as data corruptions and makes them distrust the system.

Please keep the tables in "sync" and don't corrupt users data. The origin and destination should look identical.

To fix, perhaps re-use the same code you use in CSVs to ensure the tables are identical.

https://support.fivetran.com/hc/en-us/requests/172744