Postgres Pro
Downloads
Home   >   mailing lists

Added missing invalidations for all tables publication - Mailing list pgsql-hackers

From vignesh C
Subject Added missing invalidations for all tables publication
Date
Msg-id CALDaNm0pF6zeWqCA8TCe2sDuwFAy8fCqba=nHampCKag-qLixg@mail.gmail.com
Whole thread Raw
Responses RE: Added missing invalidations for all tables publication  ("houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>)
List pgsql-hackers
Tree view 
Hi,

Relation invalidation was missing in case of create publication and
drop publication of "FOR ALL TABLES" publication, added so that the
publication information can be rebuilt. Without these invalidation
update/delete operations on the relation will be successful in the
publisher which will later result in conflict in the subscriber.
Thanks to Amit for identifying the issue at [1]. Attached patch has
the fix for the same.
Thoughts?

[1] - https://www.postgresql.org/message-id/CAA4eK1LtTXMqu-UbcByjHw%2BaKP38t4%2Br7kyKnmBQMA-__9U52A%40mail.gmail.com

Regards,
Vignesh
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Patch: shouldn't timezone(text, timestamp[tz]) be STABLE?
Next
From: Andrew Dunstan
Date:
Subject: Re: perlcritic: prohibit map and grep in void conext