Re: Distinguish publication exclusions in object addresses

From: Nisha Moond <nisha(dot)moond412(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Peter Smith <smithpb2250(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Distinguish publication exclusions in object addresses
Date: 2026-09-16 06:30:24
Message-ID: CABdArM53w2YFFFOj+dp5Ybm96CMYm2LFmmRC3cSt=eaSA+eWVA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Sep 16, 2026 at 11:21 AM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>
> On Wed, Sep 16, 2026 at 10:21 AM Peter Smith <smithpb2250(at)gmail(dot)com> wrote:
> >
> > Some review comments for v3:
> >
> > ======
> > Commit Message
> >
> > 1.
> > Fix this by distinguishing EXCEPT entries in the object address code.
> > They are now reported as publication excluded relation, with object
> > identities indicating that the table is excluded from the publication.
> >
> > ~
> >
> > Should "publication excluded relation" be quoted here?
> >
>
> I have changed the commit message.
>
> >
> > ======
> > src/backend/catalog/objectaddress.c
> >
> > 2.
> > static ObjectAddress
> > -get_object_address_publication_rel(List *object,
> > +get_object_address_publication_rel(ObjectType objtype, List *object,
> > Relation *relp, bool missing_ok)
> >
> > If not going to describe parameter `objType` then maybe a
> > self-documenting Assert would be good to have here.
> >
>
> Added assert in the attached patch and changed the if/else to simplify the code.
>

Should the new Assert be at the start of the function? At the current
position, we have already locked the relation and done some
unnecessary processing by then.

--
Thanks,
Nisha

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hayato Kuroda (Fujitsu) 2026-09-16 06:34:31 RE: pg_createsubscriber does not check output_plugin_libraries
Previous Message Richard Guo 2026-09-16 06:23:43 ERROR: no relation entry for relid 3