Re: Creation of temporary tables on a publisher

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;

Thanks & Regards,
*Shreeyansh DBA Team*
www.shreeyansh.com

On Thu, Jan 24, 2019 at 4:16 AM Cory Nemelka <cnemelka(at)gmail(dot)com> wrote:

> Postgresql v10.6
>
> After 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
>