Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
Sylvain MARECHAL
Date:
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

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

From
Sylvain MARECHAL
Date:


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