lrbug2.sql

application/sql

Download

DROP PUBLICATION IF EXISTS pub3;
DROP PUBLICATION IF EXISTS pub4;
DROP TABLE IF EXISTS t2;
SELECT pg_drop_replication_slot('test2');

CREATE TABLE  t2 (
	c1 int,
	c2 int GENERATED ALWAYS AS (c1 % 10) STORED
);

CREATE PUBLICATION pub3 for TABLE t2 WITH (publish_generated_columns = 'stored');
CREATE PUBLICATION pub4 for TABLE t2 WITH (publish_generated_columns = 'none');

SELECT * FROM pg_create_logical_replication_slot('test2', 'pgoutput');

INSERT INTO t2 (c1) VALUES(1);
INSERT INTO t2 (c1) VALUES(2);

SELECT * FROM pg_logical_slot_get_binary_changes('test2', NULL, NULL, 'proto_version', '3', 'publication_names', 'pub3, pub4');
SELECT * FROM pg_logical_slot_get_binary_changes('test2', NULL, NULL, 'proto_version', '3', 'publication_names', 'pub3, pub4');