On Wed, 2024-02-28 at 16:09 +0100, Dominique Devienne wrote: > 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.
Isn't almost all of that functionality covered by a view?
Views can have foreign-keys?
Generated view columns be indexed? (for efficient CASCADE of the FKs)
AFAIK, no. Plus that would double the relations in schemas too. --DD