Re: pg_get_object_address reports a published relation as non-existent - Mailing list pgsql-hackers

From Manuel Reyes Bravo
Subject Re: pg_get_object_address reports a published relation as non-existent
Date
Msg-id CA+bCEdCUEVL=6QAE2Pmj5evqKtvePBeOmOoAxVF7agTx4-=iWg@mail.gmail.com
Whole thread
In response to Re: pg_get_object_address reports a published relation as non-existent  (Álvaro Herrera <alvherre@kurilemu.de>)
List pgsql-hackers
Hi Álvaro,

Yes, it does. The address names a catalog row, not a (table,
publication) pair: FOR TABLE gives a pg_publication_rel row, FOR TABLES
IN SCHEMA gives a pg_publication_namespace row, which is how
object_address.sql round-trips it ('publication namespace', '{addr_nsp}',
'{addr_pub_schema}'), and FOR ALL TABLES gives nothing beyond the
publication itself, as pg_depend shows. So nothing is missing, and
comparing with pg_publication_tables was the wrong frame.

I withdraw the patch.

Regards,
Manu



pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Re: issues with eager aggregation
Next
From: Xuneng Zhou
Date:
Subject: Re: Reject WAIT FOR earlier in transaction-snapshot mode