Non-Stored Generated Columns - Mailing list pgsql-general

From Dominique Devienne
Subject Non-Stored Generated Columns
Date
Msg-id CAFCRh-_DodmoxMAS5r1sh9sAeAKDKReDiSKYH=rMLyEE3TpzQA@mail.gmail.com
Whole thread Raw
Responses Re: Non-Stored Generated Columns  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Non-Stored Generated Columns  (Peter Eisentraut <peter@eisentraut.org>)
List pgsql-general
Hi.

From https://www.postgresql.org/docs/16/ddl-generated-columns.html:
> PostgreSQL currently implements only stored generated columns

We use generated columns extensively.
And we have foreign-keys attached to those generated columns.
The fact they are always Stored thus wastes space in our case.
Any chance PostgreSQL might gain actual virtual / non-stored generated columns soon? Ever?

For reference, both Oracle and SQLite have virtual / non-stored columns.
And both support FKs and indexes on those too.
Would be great to have feature parity on this particular point, eventually.

Thanks, --DD

pgsql-general by date:

Previous
From: Riivo Kolka
Date:
Subject: Re: Orphan table files at data/base/
Next
From: Jason Long
Date:
Subject: Re: PostgreSQL Guard