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 | BEGIN 0/2B823A8 | 1973 | table "data": INSERT: id[int4]:14 data[text]:1 0/2B823A8 | 1973 | table "data": INSERT: id[int4]:15 data[text]:1 0/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.) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers