Horton

Re: Added schema level support for publication.

Amit Kapila <amit.kapila16@gmail.com>

View thread View on postgr.es
From: Amit Kapila <amit.kapila16@gmail.com>
To: vignesh C <vignesh21@gmail.com>
Cc: Artur Zakirov <zaartur@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, "tanghy.fnst@fujitsu.com" <tanghy.fnst@fujitsu.com>, "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>, Ajin Cherian <itsajin@gmail.com>, Rahila Syed <rahilasyed90@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Date: 2025-02-18T09:26:07Z
Lists: pgsql-hackers 
On Fri, Dec 20, 2024 at 11:34 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> I agree with the proposed patch and this behavior. It is on the lines
> of what Tom proposed as one of the ways to address the issue raised in
> his initial email. Also, it follows the existing behavior in cases
> like view<->function dependency as shown by you in this email, and to
> some extent subscription<->publication dependency as shown in email
> [1].
>
> Let's wait till the beginning of the next CF to see if there are other
> suggestions or any arguments against this proposed change.
>

I am planning to push Vignesh's proposed patch in the email (1) in a
day or two unless there are objections or any other comments on the
patch.

(1) - https://www.postgresql.org/message-id/CALDaNm1TQqBC5ZP5BsNf2LKVu1kEJNJn2spFwbAtyLn1FoAFGQ%40mail.gmail.com

-- 
With Regards,
Amit Kapila.

Commits

  1. Include schema/table publications even with exclude options in dump.

  2. Rename some enums to use TABLE instead of REL.

  3. Add tap tests for the schema publications.

  4. Allow publishing the tables of schema.

  5. In pg_dump, use simplehash.h to look up dumpable objects by OID.