On 02.06.21 03:10, Peter Smith wrote:
The documentation of ALTER SUBSCRIPTION REFRESH PUBLICATION [1] says:
But I found that default copy_data = true to be unintuitive. e.g. When I had previously done the CREATE SUBSCRIPTION using copy_data = false, then I assumed (wrongly) that the subscription default would remain as copy_data = false even when doing the REFRESH PUBLICATION. 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.
