-- fails, binary plugin, textual consumer

SELECT data FROM pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'force-binary', '1');

ERROR: output plugin cannot producetext output

ERROR: output plugin cannot producebinary output

-- succeeds, textual plugin, binary consumer

SELECT data FROM pg_logical_slot_get_binary_changes('regression_slot', NULL, NULL, 'force-binary', '0');

data

-- fail

SELECT pg_drop_replication_slot('regression_slot');

ERROR: replication slot "regression_slot" does not exist

-- check that we're detecting a streaming rep slot used for logical decoding

-- check that we're detecting a streaming rep slot used for logical decoding

SELECT 'init' FROM pg_create_physical_replication_slot('repl');

?column?

----------