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

From: Ajin Cherian <itsajin(at)gmail(dot)com>
To: Roberto Mello <roberto(dot)mello(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-30 04:42:48
Message-ID: CAFPTHDZNkQEU+5cS5miG9cZ8Ei29uTNJLqj4F9v7SpHYPxTotQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Mar 28, 2026 at 6:54 AM Roberto Mello <roberto(dot)mello(at)gmail(dot)com> wrote:
>
> On Fri, Mar 27, 2026 at 11:27 AM Roberto Mello <roberto(dot)mello(at)gmail(dot)com> wrote:
>>
>> On Thu, Mar 26, 2026 at 10:07 PM Ajin Cherian <itsajin(at)gmail(dot)com> wrote:
>>>
>>>
>>> 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.
>
>
> Here's v3 of the patch with the missing test.

LGTM

regards,
Ajin Cherian
Fujitsu Australia

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2026-03-30 04:50:22 Re: Better shared data structure management and resizable shared data structures
Previous Message shveta malik 2026-03-30 04:36:58 Re: Skipping schema changes in publication