Re: [HACKERS] generated columns

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

To: Pavel Stehule <pavel.stehule@gmail.com>, Michael Paquier <michael@paquier.xyz>

Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, Sergei Kornilov <sk@zsrv.org>, Michael Paquier <michael.paquier@gmail.com>, Jaime Casanova <jaime.casanova@2ndquadrant.com>

Date: 2019-01-16T08:26:10Z

Lists: pgsql-hackers

On 15/01/2019 08:18, Pavel Stehule wrote:
> I would to have a mechanism for safe replacement of triggers of type
> 
> if TG_TYPE = 'INSERT' THEN
>   NEW.inserted := CURRENT_TIMESTAMP;
> ELSE IF TG_TYPE = 'UPDATE' THEN
>   NEW.updated := CURRENT_TIMESTAMP;
>  ..

That kind of use is probably better addressed with a temporal facility.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

Generated columns
- fc22b6623b6b 12.0 landed
Add walreceiver API to get remote server version
- 69039fda837d 12.0 landed
Add pg_partition_tree to display information about partitions
- d5eec4eefde7 12.0 cited
pg_restore: Augment documentation for -N option
- 2fe42baf7c1a 12.0 cited
Change delimiter used for display of NextXID
- 59a884e9854c 9.6.0 cited