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

From: "Haiyang Li" <mohen(dot)lhy(at)alibaba-inc(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-bugs" <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Subject: Re: BUG #19100: Different column type between partitioned table and detached pending partition table make errors
Date: 2025-11-05 14:59:39
Message-ID: 59eb6b0d-7e3e-4de3-ab2e-832b623be84a.mohen.lhy@alibaba-inc.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

From: Haiyang Li <mohen(dot)lhy(at)alibaba-inc(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Langote 2025-11-06 10:00:33 Re: BUG #19099: Conditional DELETE from partitioned table with non-updatable partition raises internal error
Previous Message Tom Lane 2025-11-05 14:49:56 Re: BUG #19104: Does regexp_substr function support non-greedy matching?