etl-with-airflow | ETL best practices with airflow , with examples | Testing library

You could try to set identity to full, with will use whole row as identifier ALTER TABLE name REPLICA IDENTITY FULL;

or if it has unique index ALTER TABLE name USING INDEX index_name;

By default it will use primary key and I suppose there isn't one.

On a side note, why are you publishing temp table? I think you should remove it as I see no point in replicating temp table. Find your pub name SELECT * FROM pg_publication; and delete temp table from it: ALTER PUBLICATION name DROP TABLE [ ONLY ] table_name [ * ] [, ...]