On Fri, 5 Sept 2025 at 11:57, Shlok Kyal <[email protected]> wrote: > > On Mon, 25 Aug 2025 at 13:38, Shlok Kyal <[email protected]> wrote: > > > > On Thu, 21 Aug 2025 at 05:33, Peter Smith <[email protected]> wrote: > > > > > > Hi Shlok, > > > > > > I reviewed your latest v20-0003 patch and have no more comments at > > > this time; I only found one trivial typo. > > > > > > ====== > > > src/bin/psql/describe.c > > > > > > 1. > > > + /* > > > + * Footers entries for a publication description or a table > > > + * description > > > + */ > > > > > > Typo. /Footers entries/Footer entries/ > > > > > > > I have fixed it and attached the updated patches > > > The patches were not applying on HEAD and needed a Rebase. Here is the > rebased patches
Consider the following scenario: create table t1(c1 int, c2 int); create publication pub1 for table t1 except (c1, c2); In this case, the publication is created in such a way that no columns are included, so effectively no data will be replicated to the subscriber. However, when attempting an UPDATE, the following error occurs: postgres=# update t1 set c1 = 2; ERROR: cannot update table "t1" because it does not have a replica identity and publishes updates HINT: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE. Is this behavior expected? Regards, Vignesh
