Re: Changeset Extraction v7.5

On Fri, February 7, 2014 22:09, Thom Brown wrote:

>>The example also shows output from pg_decoding_slot_get_changes after
>>inserting 2 rows, but when I run the same example, there are no rows

FWIW, works for me:

testdb=# SELECT * FROM pg_decoding_slot_get_changes('regression_slot', 'now', 'include-xids', '0');location | xid |
data
----------+-----+------
(0 rows)

testdb=# BEGIN; INSERT INTO data(data) VALUES('1'); INSERT INTO data(data) VALUES('1'); COMMIT;
testdb=# SELECT * FROM pg_decoding_slot_get_changes('regression_slot', 'now', 'include-xids', '0');location  | xid  |
                  data
 
-----------+------+------------------------------------------------0/2B81ED0 | 1973 | BEGIN0/2B823A8 | 1973 | table
"data":INSERT: id[int4]:14 data[text]:10/2B823A8 | 1973 | table "data": INSERT: id[int4]:15 data[text]:10/2B823A8 |
1973| COMMIT
 
(4 rows)

testdb=# SELECT * FROM pg_decoding_slot_get_changes('regression_slot', 'now', 'include-xids', '0');location | xid |
data
----------+-----+------
(0 rows)


( output of "SELECT * FROM pg_replication_slots;" is, indeed, out-of-date.)