| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Alberto Piai <alberto(dot)piai(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Cc: | Álvaro Herrera <alvherre(at)kurilemu(dot)de> |
| Subject: | Re: Adding a stored generated column without long-lived locks |
| Date: | 2026-08-26 05:20:18 |
| Message-ID: | 57bd5c0e2b532c07a1e6cd867520e899b1007622.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 2026-08-25 at 18:13 +0200, Alberto Piai wrote:
> 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.
Both variants look fine to me. Pick the one you prefer.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Guo | 2026-08-26 05:26:42 | Re: remove_useless_joins vs. bug #19560 |
| Previous Message | Bharath Rupireddy | 2026-08-26 05:19:30 | Re: Assertion failure in GetSubscriptionRelations() with concurrent DROP TABLE |