MIME-Version: 1.0
References: <19434-297bf2cbd8d2931a@postgresql.org> <CAKAnmm+csbrmkn5SFUd60SAAfe9P1+srbjuEPWvH+3XNCvDrwA@mail.gmail.com>
In-Reply-To: <CAKAnmm+csbrmkn5SFUd60SAAfe9P1+srbjuEPWvH+3XNCvDrwA@mail.gmail.com>
From: Tim McLaughlin <tim@gotab.io>
Date: Mon, 23 Mar 2026 15:49:22 -0400
Message-ID: <CAA6J38J6S8k2gixxGJ9C_VfXKRdTdsRJJpWFqpLMeqqHFtvE8w@mail.gmail.com>
Subject: Re: BUG #19434: adding WHERE to a publication can cause UPDATEs and
 DELETEs to fail on the source table
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000786017064db65557"
Archived-At: <https://www.postgresql.org/message-id/CAA6J38J6S8k2gixxGJ9C_VfXKRdTdsRJJpWFqpLMeqqHFtvE8w%40mail.gmail.com>
Precedence: bulk

--000000000000786017064db65557
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Thanks for the feedback, Greg.

Cheers,
Tim
+1-571-263-1023


On Mon, Mar 23, 2026 at 12:47=E2=80=AFPM Greg Sabino Mullane <htamfids@gmai=
l.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 c=
c
> you on that.
>
> Cheers,
> Greg
>
>

--000000000000786017064db65557
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Thanks for the feedback, Greg.=C2=A0<br clear=3D"all"><br=
 clear=3D"all"><div><div dir=3D"ltr" class=3D"gmail_signature" data-smartma=
il=3D"gmail_signature"><div dir=3D"ltr">Cheers,<div>Tim</div><div>+1-571-26=
3-1023</div></div></div></div></div><div><br></div><div><br><div class=3D"g=
mail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On =
Mon, Mar 23, 2026 at 12:47=E2=80=AFPM Greg Sabino Mullane &lt;<a href=3D"ma=
ilto:htamfids@gmail.com">htamfids@gmail.com</a>&gt; wrote:<br></div><blockq=
uote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc =
solid;padding-left:1ex"><div dir=3D"ltr">I don&#39;t think this is really a=
 bug, more of a feature request / optimization. However, I do agree this is=
 an important one. I don&#39;t see offhand why we can&#39;t append the wher=
e list to our existing list of important columns. There would be a few down=
sides, but none that would be worse than going full replica identity or cre=
ating a new index. I&#39;ll see about making a proof of concept patch and t=
hrowing it on -hackers. Will cc you on that.<div><br></div><div>Cheers,</di=
v><div>Greg</div><div><br></div></div>
</blockquote></div></div>

--000000000000786017064db65557--