| From: | Noah Misch <noah(at)leadboat(dot)com> |
|---|---|
| To: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
| Cc: | Ajin Cherian <itsajin(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Add support for COPY TO in tablesync for partitioned tables. |
| Date: | 2026-09-05 04:00:20 |
| Message-ID: | 20260905040020.57.noahmisch@microsoft.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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".
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.
| From | Date | Subject | |
|---|---|---|---|
| Previous Message | shihao zhong | 2026-09-05 03:56:44 | Re: aio: Don't silently drop wait_event_info |