Re: tablecmds: reject CLUSTER ON for partitioned tables earlier

Поиск
Список
Период
Сортировка
От Chao Li
Тема Re: tablecmds: reject CLUSTER ON for partitioned tables earlier
Дата
Msg-id 8A3FAABD-F297-41D1-9B07-20A37E311C29@gmail.com
обсуждение исходный текст
Ответ на Re: tablecmds: reject CLUSTER ON for partitioned tables earlier  (Chao Li <li.evan.chao@gmail.com>)
Список pgsql-hackers

> On Jan 28, 2026, at 10:15, Chao Li <li.evan.chao@gmail.com> wrote:
>
>
>
>> On Jan 27, 2026, at 16:55, Zsolt Parragi <zsolt.parragi@percona.com> wrote:
>>
>>> I added two new test cases in 0002 that trigger the check.
>>
>> I also tested these scenarios previously. It's good that they are part
>> of the test suite, but they don't hit that error path. Verified with
>> this:
>>
>> diff --git a/src/backend/commands/tablecmds.c b/src/backend/commands/tablecmds.c
>> index 379f4d4ebaf..50f80724cb3 100644
>> --- a/src/backend/commands/tablecmds.c
>> +++ b/src/backend/commands/tablecmds.c
>> @@ -17857,9 +17857,7 @@ ATExecDropInherit(Relation rel, RangeVar
>> *parent, LOCKMODE lockmode)
>> Relation parent_rel;
>>
>> if (rel->rd_rel->relispartition)
>> - ereport(ERROR,
>> - (errcode(ERRCODE_WRONG_OBJECT_TYPE),
>> - errmsg("cannot change inheritance of a partition")));
>> + Assert(0);
>>
>> /*
>> * AccessShareLock on the parent is probably enough, seeing that DROP
>
> Thank you so much for pointing out this, and sorry for misunderstanding you. You are right, as the check has been
addedto ATPrepChangeInherit(), the same check in ATExecDropInherit becomes redundant. I thought you were talking about
thecheck in ATPrepChangeInherit(). 
>
> PFA v7:
>
> * In 0001, replaced ereport with assert in mark_index_clustered(). See my previous email for the analysis.
> * In 0002, removed the redundant check of relispartition from ATExecDropInherit().
>
> Best regards,
> --
> Chao Li (Evan)
> HighGo Software Co., Ltd.
> https://www.highgo.com/
>
>
>
>
>
<v7-0001-tablecmds-reject-CLUSTER-ON-for-partitioned-table.patch><v7-0002-tablecmds-reject-INHERIT-NO-INHERIT-for-partition.patch>

PFA v8: rebase requested by CF https://commitfest.postgresql.org/patch/6415/

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/





Вложения

В списке pgsql-hackers по дате отправления: