Horton

Re: [HACKERS] Re: [HACKERS] generated columns

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

View thread View on postgr.es
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Joe Conway <mail@joeconway.com>, Jaime Casanova <jaime.casanova@2ndquadrant.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2018-01-02T14:31:04Z
Lists: pgsql-hackers 
On 12/31/17 12:54, Joe Conway wrote:
> Anyway, I have seen requests for change data capture
> (https://en.wikipedia.org/wiki/Change_data_capture) in Postgres which is
> apparently available in our competition without requiring the use of
> triggers. Perhaps that is yet a different feature, but I was hopeful
> that this mechanism could be used to achieve it.

I think logical decoding provides CDC.  The generated columns feature
doesn't have much to do with that, in my mind.

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

Commits

  1. Generated columns

  2. Add walreceiver API to get remote server version

  3. Add pg_partition_tree to display information about partitions

  4. pg_restore: Augment documentation for -N option

  5. Change delimiter used for display of NextXID