Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax - Mailing list pgsql-hackers

From japin
Subject Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax
Date
Msg-id MEYP282MB1669C0F4B13CFE43DEDFFE03B6859@MEYP282MB1669.AUSP282.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
List pgsql-hackers
On Tue, 16 Feb 2021 at 09:58, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> wrote:
> On Mon, Feb 15, 2021 at 8:13 AM Bharath Rupireddy
> <bharath.rupireddyforpostgres@gmail.com> wrote:
>>
>> On Sat, Feb 13, 2021 at 11:41 AM japin <japinli@hotmail.com> wrote:
>> > > IIUC, with the current patch, the new ALTER SUBSCRIPTION ... ADD/DROP
>> > > errors out on the first publication that already exists/that doesn't
>> > > exist right? What if there are multiple publications given in the
>> > > ADD/DROP list, and few of them exist/don't exist. Isn't it good if we
>> > > loop over the subscription's publication list and show all the already
>> > > existing/not existing publications in the error message, instead of
>> > > just erroring out for the first existing/not existing publication?
>> > >
>> >
>> > Yes, you are right. Agree with you, I modified it. Please consider v5
>> > for further review.
>>
>> Thanks for the updated patches. I have a comment about reporting the
>> existing/not existing publications code. How about something like the
>> attached delta patch on v5-0002?
>
> Attaching the v6 patch set so that cfbot can proceed to test the
> patches. The above delta patch was merged into 0002. Please have a
> look.
>

Thanks for the updated patches. I'm on vacation.

-- 
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: cryptohash: missing locking functions for OpenSSL <= 1.0.2?
Next
From: Etsuro Fujita
Date:
Subject: Re: Asynchronous Append on postgres_fdw nodes.