public inbox for [email protected]
help / color / mirror / Atom feedFrom: Chao Li <[email protected]>
To: Postgres hackers <[email protected]>
Cc: Greg Sabino Mullane <[email protected]>
Cc: Jim Jones <[email protected]>
Cc: David G. Johnston <[email protected]>
Cc: Zsolt Parragi <[email protected]>
Subject: Re: ALTER TABLE: warn when actions do not recurse to partitions
Date: Wed, 1 Apr 2026 16:01:56 +0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CAEoWx2=SLga-xH09Cq_PAvsHhQHrBK+V0vF821JKgzS=Bm0haA@mail.gmail.com>
<CAKFQuwZXt2dAuHFs6MtRCzfMP6YZFzssuzdW2woJBVmco=CDdQ@mail.gmail.com>
<CAEoWx2nic2MaPUEKwb0Me1iwO3LsCf8wUHm55pjqaTRgJEZpcQ@mail.gmail.com>
<CAKFQuwahxpPKT-LXGJ34BO5cVBUxFxzgNPTY8E_VW-cuNU_DkQ@mail.gmail.com>
<CAEoWx2kQ9aSn-0LGPKc=woj+h-HR4uBV9TL20aeM3HzLmFqgFQ@mail.gmail.com>
<[email protected]>
<[email protected]>
<CAEoWx2mZsWnyS_XLDL5mL+yuU_g65p_tmHNesyfngqow7gtS3A@mail.gmail.com>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<CAKAnmmKzzOWKQVhaAt8LrBmUW=FLWBqS4v8cwKOG53hBToQZRA@mail.gmail.com>
<[email protected]>
<CAKAnmmLWdEvFR+-+5HXzMEnd8fLfyvkK4QxtSHMBhoXC5Qvcug@mail.gmail.com>
<[email protected]>
<CAKAnmm+G2OHo8R-VqBwwcH7Xro2w9-Gv8Q6mctNKk5c-6eGnmQ@mail.gmail.com>
<[email protected]>
<CAN4CZFOrFYa3JBLAK7ncKNyykk37QU9YUrZKEe_OWoFDCzMHEA@mail.gmail.com>
<[email protected]>
> On Mar 13, 2026, at 11:16, Chao Li <[email protected]> wrote:
>
>
>
>> On Mar 13, 2026, at 05:45, Zsolt Parragi <[email protected]> wrote:
>>
>> Hello
>>
>>> Affected sub-commands include:
>>> ...
>>
>> Shouldn't SET ACCESS METHOD be included in this list?
>>
>> It only changes the catalog entry for the parent, existing partitions
>> stay as-is. It only sets the access method for future direct child
>> partitions.
>
> Good catch. I missed SET ACCESS METHOD. Thanks a lot.
>
> PFA v9:
> * Included SET ACCESS METHOD
> * Added a new test case where if the sub-command fails, then the notice message should not show up
>
> Best regards,
> --
> Chao Li (Evan)
> HighGo Software Co., Ltd.
> https://www.highgo.com/
>
>
>
>
> <v9-0001-ALTER-TABLE-emit-NOTICE-when-ONLY-is-omitted-but-.patch>
PFA v10 - fixed a test failure.
Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/
view thread (19+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: ALTER TABLE: warn when actions do not recurse to partitions
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox