Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting the value of the old_tuple using the test_decoding extension and BDR - Mailing list pgsql-general

From Sylvain MARECHAL
Subject Re: Getting the value of the old_tuple using the test_decoding extension and BDR
Date
Msg-id CAJu=pHQGUxHnB8E9SjSMJbDeWbQ3K+SKq5QtcriswcFZVzLjiw@mail.gmail.com
Whole thread Raw
In response to Getting the value of the old_tuple using the test_decoding extension and BDR  (Sylvain MARECHAL <marechal.sylvain2@gmail.com>)
List pgsql-general
Tree view


2015-07-02 16:11 GMT+02:00 Sylvain MARECHAL <marechal.sylvain2@gmail.com>:
Hello all,

[...]

What I can see is that new values are present, and also old key when the modification concerns the primary key. But the other old values do not seem to be accessible.

Is it a limitation of the test_decoding plugin, or old values are simply not available?


I guess I simply should use the REPLICA IDENTITY ( http://www.postgresql.org/docs/9.4/static/sql-altertable.html)

<<<
ALTER TABLE
[...]
REPLICA IDENTITY
[...]
FULL records the old values of all columns in the row.
>>>

Sylvain

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: Running PostgreSQL with ZFS ZIL
Next
From: Joseph Kregloh
Date:
Subject: Re: Running PostgreSQL with ZFS ZIL