On 11/01/2019 16:22, Pavel Stehule wrote: > The documentation contains paragraph > > + The generation expression can only use immutable functions and cannot > + use subqueries or reference anything other than the current row > in any > + way. > > It is necessary for stored columns?
See here: https://www.postgresql.org/message-id/b5c27634-1d44-feba-7494-ce5a31f91...@2ndquadrant.com > I tested it with pseudo constant - current_timestamp, session_user. But > current_database() is disallowed. > > on second hand, this is strange > > postgres=# create table foo3 (inserted text generated always as > (current_timestamp) virtual); > CREATE TABLE Ah, the volatility checking needs some improvements. I'll address that in the next patch version. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
