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
