Re: Add SPLIT PARTITION/MERGE PARTITIONS commands

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Date: 2025-10-15 11:34:37
Message-ID: CACJufxHbuPsv3M9CiVvb-et2zfq+BxH3hST+AbzXOvG3fJ4WLA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi.

please check the attach doc refactor for v62-0001.

if (found_whole_row && attribute->attgenerated != '\0')
ereport(ERROR,
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
errmsg("cannot convert whole-row table reference"),
errdetail("Generation expression for column
\"%s\" contains a whole-row reference to table \"%s\".",
NameStr(attribute->attname),
RelationGetRelationName(parent_rel)));

here ereport should be elog(ERROR...).
since this error should be unreachable. see check_nested_generated, cookDefault.

/*
* For the moment we have to reject whole-row variables (as for LIKE
* and inheritances).
*/
if (found_whole_row)
elog(ERROR, "Constraint \"%s\" contains a whole-row
reference to table \"%s\".",
ccname,
RelationGetRelationName(parent_rel));

"table \"%s\".", we don't need that extra period.

"(as for LIKE and inheritances)":
I think you meant, “CREATE TABLE LIKE and table inheritance reject
whole-row check constraint, here we will do the same”.
maybe change to ""(as for CREATE TABLE LIKE and inheritances)".

Overall, I found v62-0001 code makes sense to me.

Attachment Content-Type Size
v62-0001-doc-refactor-alter-table-merge-partitions-v62.no-cfbot application/octet-stream 6.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2025-10-15 12:35:44 Re: MergeAppend could consider sorting cheapest child path
Previous Message Álvaro Herrera 2025-10-15 11:33:41 Re: [PATCH] Remove make_temptable_name_n()