agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Alberto Piai <alberto.piai@gmail.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
To: Alberto Piai <alberto.piai@gmail.com>
To: pgsql-hackers@postgresql.org
Cc: Álvaro Herrera <alvherre@kurilemu.de>
Subject: Re: Adding a stored generated column without long-lived locks
Date: Tue, 25 Aug 2026 18:13:05 +0200
Message-ID: <DKY5OJ1NSSGO.3U2FKRKCHM533@gmail.com> (raw)
In-Reply-To: <86a9336dc25d9a085916ad247a5791dc53d2ab13.camel@cybertec.at>
References: <DIIRFCWJIA80.2Q5DYIX6C7KZ5@gmail.com>
<DITN90YX3328.2A0I3LCV164BA@gmail.com>
<3af338791e8ab27c4a7efbc4217c97162de76bc8.camel@cybertec.at>
<DJMFASI8OYBS.2JBMQ7KZ2XOTO@gmail.com>
<DJOPT622HYJK.3JRH1VQCV5CDL@gmail.com>
<2eb68e74ea95fc2f691de7d8cd28448d00d1d216.camel@cybertec.at>
<DJUGET7QLNRK.7G2H4M2PPJM9@gmail.com>
<79b63e772179abb4f5ad749d9e067d48a5537599.camel@cybertec.at>
<DKHUPZ08JV6G.2938OV580K72C@gmail.com>
<6f5ea02f6e5205a96a9b3979190a4d7cb3c99414.camel@cybertec.at>
<DKXFEG915LK8.12HECZQW2OWQE@gmail.com>
<86a9336dc25d9a085916ad247a5791dc53d2ab13.camel@cybertec.at>
On Tue Aug 25, 2026 at 10:46 AM CEST, Laurenz Albe wrote:
> On Mon, 2026-08-24 at 22:03 +0200, Alberto Piai wrote:
>> > I was wondering about this hint:
>> >
>> > Use this command on the root table/partition without ONLY.
>> >
>> > You can never turn a column of a partition into a generated column, right?
>> > How about
>> >
>> > Use the command on the partition root without specifying ONLY.
>>
>> Since this is also taking care of classic inheritance, it seems strange
>> to only mention partitions. But I see that this way it's confusing (and
>> I do concede that partitioning might be the more widely used of the two)
>> so I switched it around to "on the root partition/table without
>> specifying ONLY". Does that make more sense?
>
> My problem is that there is no "root partition".
Ah, I see what you mean now. I agree, "root partition" makes no sense.
So, removing the slash, it would look like:
ERROR: cannot convert column "c" to generated
DETAIL: Converting only part of a partitioning or inheritance hierarchy is not supported.
HINT: Use this command on the partitioning or inheritance root without specifying ONLY.
Maybe a bit heavy on the eye?
Since the root of the hierarchy is in both cases just a table
(partitoned or not), what about just calling it a table?
ERROR: cannot convert column "c" to generated
DETAIL: Converting only part of a partitioning or inheritance hierarchy is not supported.
HINT: Use this command on the root table without specifying ONLY.
Regards,
Alberto
--
Alberto Piai
Sensational AG
Zürich, Switzerland
view thread (36+ messages) latest in thread
Message-ID: <DKY5OJ1NSSGO.3U2FKRKCHM533@gmail.com>
Permalink: ../DKY5OJ1NSSGO.3U2FKRKCHM533@gmail.com/
Also on: postgresql.org/message-id/DKY5OJ1NSSGO.3U2FKRKCHM533@gmail.com
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: pgsql-hackers@postgresql.org
Cc: alberto.piai@gmail.com, laurenz.albe@cybertec.at, alvherre@kurilemu.de
Subject: Re: Adding a stored generated column without long-lived locks
In-Reply-To: <DKY5OJ1NSSGO.3U2FKRKCHM533@gmail.com>
* 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