Getting the value of the old_tuple using the test_decoding extension and BDR
Hello all,
I am playing with the test_decoding extension to be notified on database
changes in a couple of databases replicated with BDR.
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?
Thanks,
Sylvain
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