Request a Demo
Home   >   mailing lists

Re: BUG #19100: Different column type between partitioned table and detached pending partition table make errors - Mailing list pgsql-bugs

From Haiyang Li
Subject Re: BUG #19100: Different column type between partitioned table and detached pending partition table make errors
Date
Msg-id 59eb6b0d-7e3e-4de3-ab2e-832b623be84a.mohen.lhy@alibaba-inc.com
Whole thread Raw
In response to Re: BUG #19100: Different column type between partitioned table and detached pending partition table make errors  ("Haiyang Li" <mohen.lhy@alibaba-inc.com>)
List pgsql-bugs
Tree view
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


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #19104: Does regexp_substr function support non-greedy matching?