Re: Add support for COPY TO in tablesync for partitioned tables.

On Fri, Sep 4, 2026 at 9:00 PM Noah Misch <noah(at)leadboat(dot)com> wrote:
>
> On Thu, Nov 20, 2025 at 03:09:36PM -0800, Masahiko Sawada wrote:
> > Pushed.
>
> This became commit 266543a. It doesn't account for the publisher version, so
> replicating v18->v19 w/ publish_via_partition_root fails at tablesync w/
> "ERROR: cannot copy from partitioned table".

Good catch. I've attached the patch to fix it.

> I think commit 266543a also changes the behavior w/ foreign table partitions.
> A v19 subscriber will fail w/ "cannot copy from foreign table", whereas an
> older subscriber would have completed tablesync but handled no further foreign
> table changes. This consequence of 266543a is a net good, since the v18
> subscriber behavior is mostly a bug. Let's keep it. If someone really needs
> the v18 subscriber behavior, adding a no-op row filter achieves that.

Agreed.

Regards,

--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com