Horton

Re: BUG #19100: Different column type between partitioned table and detached pending partition table make errors

Haiyang Li <mohen.lhy@alibaba-inc.com>

View thread
From: "Haiyang Li" <mohen.lhy@alibaba-inc.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "pgsql-bugs" <pgsql-bugs@lists.postgresql.org>, Álvaro Herrera <alvherre@kurilemu.de>
Date: 2025-11-05T14:59:39Z
Lists: pgsql-bugs 
From: Haiyang Li <mohen.lhy@alibaba-inc.com> 2025-11-3 17:16 write:
> OTOH, from a safety perspective, I would argue that pg_dump should avoid
> emitting ATTACH PARTITION statements for detach pending child tables.
I mean that if detach pending state is considered closer to the detached state,
then it would be more reasonable for pg_dump to avoid generating ATTACH
statements for detach pending tables. This makes more sense to me.
Regards,
Haiyang Li