Non-Stored Generated Columns

Поиск
Список
Период
Сортировка
От Dominique Devienne
Тема Non-Stored Generated Columns
Дата
Msg-id CAFCRh-_DodmoxMAS5r1sh9sAeAKDKReDiSKYH=rMLyEE3TpzQA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Non-Stored Generated Columns
Re: Non-Stored Generated Columns
Список 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 по дате отправления:

Предыдущее
От: Riivo Kolka
Дата:
Сообщение: Re: Orphan table files at data/base/
Следующее
От: Jason Long
Дата:
Сообщение: Re: PostgreSQL Guard