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

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".

Perhaps

Use the command on the partitioning or inheritance root without specifying ONLY.

> > This detail message is longer than 80 characters:
> >
> >    Converting a column to a stored generated column can only be done on the whole hierarchy at once.
> >
> > How about
> >
> >    Converting only part of a partitioning/inheritance hierarchy is not supported.
>
> Much better, fixed.

I am having second thoughts about the slash.
Perhaps it would be better to use "or" instead.

Yours,
Laurenz Albe