Creation of temporary tables on a publisher - Mailing list pgsql-admin

From Cory Nemelka
Subject Creation of temporary tables on a publisher
Date
Msg-id CAMe5Gn0o=Ptrfup9Owqby-MCUPHrsrZ4RVo5GYa2r_5S29xy5w@mail.gmail.com
Whole thread Raw
Responses Re: Creation of temporary tables on a publisher  (Shreeyansh Dba <shreeyansh2014@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Pepe TD Vo
Date:
Subject: Re: ora2pg perl module error
Next
From: Shreeyansh Dba
Date:
Subject: Re: Creation of temporary tables on a publisher