Re: [HACKERS] generated columns

Hi

pá 11. 1. 2019 v 9:31 odesílatel Peter Eisentraut <
peter(dot)eisentraut(at)2ndquadrant(dot)com> napsal:

> 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
>