Re: ALTER SUBSCRIPTION REFRESH PUBLICATION has default copy_data = true? - Mailing list pgsql-hackers

From Peter Smith
Subject Re: ALTER SUBSCRIPTION REFRESH PUBLICATION has default copy_data = true?
Date
Msg-id CAHut+Pv=zY_hmUsehMdFJmgZpGKRmazOEJHMm7T8d2Pf4Lv=LQ@mail.gmail.com
Whole thread Raw
In response to Re: ALTER SUBSCRIPTION REFRESH PUBLICATION has default copy_data = true?  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
List pgsql-hackers
On Thu, Jun 3, 2021 at 12:52 AM Peter Eisentraut
<peter.eisentraut@enterprisedb.com> wrote:
> > Is that a deliberate functionality, or is it a quirk / bug?
>
> copy_data is an option of the action, not a property of the
> subscription.  The difference between those two things is admittedly not
>   clearly (at all?) documented.
>
> However, I'm not sure whether creating a subscription that always
> defaults to copy_data=false for tables added in the future is useful
> functionality, so I think the current behavior is okay.

...

On Thu, Jun 3, 2021 at 12:53 AM Bharath Rupireddy
<bharath.rupireddyforpostgres@gmail.com> wrote:
> > Is that a deliberate functionality, or is it a quirk / bug?
>
> I don't think it's a bug....

...

OK. Thanks to both of you for sharing your thoughts about it.

------
Kind Regards,
Peter Smith
Fujitsu Australia



pgsql-hackers by date:

Previous
From: "ikedamsh@oss.nttdata.com"
Date:
Subject: Re: Transactions involving multiple postgres foreign servers, take 2
Next
From: Justin Pryzby
Date:
Subject: Re: please update ps display for recovery checkpoint