Re: pg_publication_tables: return NULL attnames when no column list is specified

From: Roberto Mello <roberto(dot)mello(at)gmail(dot)com>
To: Ajin Cherian <itsajin(at)gmail(dot)com>
Cc: Peter Smith <smithpb2250(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_publication_tables: return NULL attnames when no column list is specified
Date: 2026-03-27 17:27:16
Message-ID: CAKz==bLYWG43n6J0Ze1Y5fgyrW32_73WQkNSPbWGmFwLE8Aa0A@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Mar 26, 2026 at 10:07 PM Ajin Cherian <itsajin(at)gmail(dot)com> wrote:

>
> Tested the patch and the patch fixes the bug as described. My tests below:
>

Thank you for the review.

<snip>

One observation from reviewing the patch: the test suite covers the
> partial column list and dropped column cases well, but is missing a
> test for the two-publication conflict scenario (one pub with no list +
> one pub with an explicit list of all columns on the same table). That
> is the breaking change called out in the original report and probably
> deserves its own regression test with a comment explaining the
> expected behavior change for users in that configuration.
> Patch LGTM otherwise.
>

Good point. I know I worked on that, so I must have accidentally dropped it
from the patch.

Will prepare a revision and submit.

Thanks again.

Roberto Mello
Snowflake

P.S.: I forgot to acknowledge and thank Greg Mullane for the initial review
on the patch, so doing that now.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2026-03-27 17:29:03 Re: Don't synchronously wait for already-in-progress IO in read stream
Previous Message Fujii Masao 2026-03-27 17:19:26 Re: Use SIGTERM instead of SIGUSR1 for slotsync worker to exit during promotion?