On 06/11/2018 13:27, Peter Eisentraut wrote: > This is a small bug that I will fix in my next update.
Time for another update. Lot's of rebasing, many things fixed, including the ADD COLUMN bug you found, replication, foreign tables, better caching, some corner cases in trigger behavior, more documentation. This addresses everything I've had in my notes, so it's functionally and logically complete from my perspective.
I am looking on this patch - it is great feature.
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?
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
Regards
Pavel
-- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services