Обсуждение: Change Data Capture

Hello,

Is there a plan to integrate Change Data Capture into the database
engine itself?
The "normal" way to track data changes are by doing triggers and
(shadow) tables, but that involves mundane work (plumbing) that the
database engine (presumably) could do better and more effecient.

Best Regards
Jan Johansson

On 11/22/10, Jan Johansson <jan.johansson.mr@gmail.com> wrote:

> Is there a plan to integrate Change Data Capture into the database
> engine itself?

Probably not until the following SQL standard feature is applied to PostgreSQL:

http://petereisentraut.blogspot.com/2010/05/system-versioned-tables.html



--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

On Mon, Nov 22, 2010 at 3:23 AM, Jan Johansson
<jan.johansson.mr@gmail.com> wrote:
> Is there a plan to integrate Change Data Capture into the database
> engine itself?
> The "normal" way to track data changes are by doing triggers and
> (shadow) tables, but that involves mundane work (plumbing) that the
> database engine (presumably) could do better and more effecient.

Some more pointers:
 * http://archives.postgresql.org/pgsql-general/2010-06/msg01295.php
 * http://www.postgresql.org/docs/current/static/contrib-spi.html#AEN124746

Josh