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

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: tim(at)gotab(dot)io, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19434: adding WHERE to a publication can cause UPDATEs and DELETEs to fail on the source table
Date: 2026-03-23 16:47:06
Message-ID: CAKAnmm+csbrmkn5SFUd60SAAfe9P1+srbjuEPWvH+3XNCvDrwA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tim McLaughlin 2026-03-23 19:49:22 Re: BUG #19434: adding WHERE to a publication can cause UPDATEs and DELETEs to fail on the source table
Previous Message Tender Wang 2026-03-22 05:15:56 Re: BUG #19435: Error: "No relation entry for relid 2" Triggered by Complex Join with Self-Referencing Tables