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? thanks Shveta
