Request a Demo
Home   >   mailing lists

Re: BUG #19434: adding WHERE to a publication can cause UPDATEs and DELETEs to fail on the source table - Mailing list pgsql-bugs

From Tim McLaughlin
Subject Re: BUG #19434: adding WHERE to a publication can cause UPDATEs and DELETEs to fail on the source table
Date
Msg-id CAA6J38J6S8k2gixxGJ9C_VfXKRdTdsRJJpWFqpLMeqqHFtvE8w@mail.gmail.com
Whole thread
In response to Re: BUG #19434: adding WHERE to a publication can cause UPDATEs and DELETEs to fail on the source table  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-bugs
Tree view
Thanks for the feedback, Greg. 

Cheers,
Tim
+1-571-263-1023


On Mon, Mar 23, 2026 at 12:47 PM Greg Sabino Mullane <htamfids@gmail.com> wrote:
I don't think this is really a bug, more of a feature request / optimization. However, I do agree this is an important one. I don't see offhand why we can't append the where list to our existing list of important columns. There would be a few downsides, but none that would be worse than going full replica identity or creating a new index. I'll see about making a proof of concept patch and throwing it on -hackers. Will cc you on that.

Cheers,
Greg

pgsql-bugs by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: BUG #19434: adding WHERE to a publication can cause UPDATEs and DELETEs to fail on the source table
Next
From: Alexander Korotkov
Date:
Subject: Re: BUG #19435: Error: "No relation entry for relid 2" Triggered by Complex Join with Self-Referencing Tables