| From: | Cory Nemelka <cnemelka(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Creation of temporary tables on a publisher |
| Date: | 2019-01-23 22:45:39 |
| Message-ID: | CAMe5Gn0o=Ptrfup9Owqby-MCUPHrsrZ4RVo5GYa2r_5S29xy5w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shreeyansh Dba | 2019-01-24 01:56:14 | Re: Creation of temporary tables on a publisher |
| Previous Message | Pepe TD Vo | 2019-01-23 17:17:12 | Re: ora2pg perl module error |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shreeyansh Dba | 2019-01-24 01:56:14 | Re: Creation of temporary tables on a publisher |
| Previous Message | Rene Romero Benavides | 2019-01-23 22:22:43 | Re: Back-out V10 upgrade but keep new data |