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

[Sylvain MARECHAL <marechal.sylvain2@xxxxxxxxx>]

2015-07-02 16:11 GMT+02:00 Sylvain MARECHAL <marechal.sylvain2@xxxxxxxxx>:

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