In Logical replication all tables have a valid default REPLICA IDENTITY (i.e. PK). If suppose there isn't one then 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;
On Thu, Jan 24, 2019 at 4:16 AM Cory Nemelka <cnemelka@xxxxxxxxx> wrote:
Postgresql v10.6After defining a publication with "FOR ALL TABLES" clause, temporary tables that are created after the definition will produce errors if they are updated,etc. The error: "cannot update table <tablename> because it does not have a replica identity and publishes updates."Is this expected behaviour? I had understood that temporary tables were not included in publications.--cnemelka
