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

Поиск
Список
Период
Сортировка
От Sylvain MARECHAL
Тема Re: Getting the value of the old_tuple using the test_decoding extension and BDR
Дата
Msg-id CAJu=pHQGUxHnB8E9SjSMJbDeWbQ3K+SKq5QtcriswcFZVzLjiw@mail.gmail.com
обсуждение исходный текст
Ответ на Getting the value of the old_tuple using the test_decoding extension and BDR  (Sylvain MARECHAL <marechal.sylvain2@gmail.com>)
Список pgsql-general


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 по дате отправления:

Предыдущее
От: Vick Khera
Дата:
Сообщение: Re: Running PostgreSQL with ZFS ZIL
Следующее
От: Joseph Kregloh
Дата:
Сообщение: Re: Running PostgreSQL with ZFS ZIL