Re: Creation of temporary tables on a publisher

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



That is my understanding also.  However, we are getting the previously mentioned error above when trying to update a temporary table  in a database that has other tables published. 

I’m not sure you understand the issue. We don’t want to temporary tables replicated but they appear to be. As I mentioned, is this expected behavior? Anyone, Bueller?

On Fri, Jan 25, 2019 at 03:30 Shreeyansh Dba <shreeyansh2014@xxxxxxxxx> wrote:
Temporary tables can't be part of a replication. In logical replication perform only DML. As well as same structure must be exists on publication and subscribe side.

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


On Thu, Jan 24, 2019 at 10:04 PM Cory Nemelka <cnemelka@xxxxxxxxx> wrote:
The issue is the apparent replication of temporary tables.  The workarounds you proposed do work but why do postgresql publications replicate temporary tables?  they will not be on the subscriber so the replication will fail.  

As I mentioned, is this expected behavior?

--cnemelka


On Wed, Jan 23, 2019 at 6:58 PM Shreeyansh Dba <shreeyansh2014@xxxxxxxxx> wrote:
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@xxxxxxxxx> 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
--
--cnemelka

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux