Re: Adding a stored generated column without long-lived locks

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