Re: Getting the value of the old_tuple using the test_decoding extension and BDR

2015-07-02 16:11 GMT+02:00 Sylvain MARECHAL <marechal(dot)sylvain2(at)gmail(dot)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