On Wed, Jul 1, 2026 at 3:46 PM shveta malik <[email protected]> wrote: > > On Wed, Jul 1, 2026 at 3:37 PM Nisha Moond <[email protected]> wrote: > > > > > > Besides the above comments, I found and fixed a few additional issues > > during further testing: > > 1) Fixed an issue where UPDATE/DELETE on an excluded table without > > replica identity was still blocked. e.g., > > > > postgres=# create publication pub_h2 for tables in schema s1 except ( table > > t1); > > postgres=# update s1.t1 set c1=3 where c1=1; > > 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. > > > > Excluded tables should not be treated as published for update/delete checks. > > Nisha, this bug was introduced by your patch or does it exist in 'ALL > TABLES Except TABLE' too? >
The same case for 'ALL TABLES Except Table' was already handled correctly as part of that feature (Ref -RelationBuildPublicationDesc()). The bug was only in my patch where I missed handling it earlier. -- Thanks, Nisha
