Postgres Pro
Downloads
Home   >   mailing lists

Re: v18 virtual columns - Mailing list pgsql-general

From Ron Johnson
Subject Re: v18 virtual columns
Date
Msg-id CANzqJaC0LCgK1RRKJ=qNTGxgkfFV-_F6keKmCxGBS6EWZ2jjKA@mail.gmail.com
Whole thread Raw
In response to v18 virtual columns  (Dominique Devienne <ddevienne@gmail.com>)
Responses Re: v18 virtual columns
List pgsql-general
Tree view
On Thu, Feb 20, 2025 at 8:07 AM Dominique Devienne <ddevienne@gmail.com> wrote:
Hi. I've just read https://www.dbi-services.com/blog/postgresql-18-virtual-generated-columns/

and I'm wondering whether there will be a way to ALTER existing STORED generated columns, to be virtual? W/o rewriting the whole table that is.

What about dropping the existing stored column then adding the new virtual column?

You won't get any disk space saving for existing records, but it's not going to rewrite the table.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: v18 virtual columns
Next
From: Dominique Devienne
Date:
Subject: #XX000: ERROR: tuple concurrently updated