How is this possible "publication does not exist" - Mailing list pgsql-hackers

From Dave Cramer
Subject How is this possible "publication does not exist"
Date
Msg-id CADK3HH+9uPg=anB-thAMojVhsZk3tYWMwux4YmHB2+ByJXcE3w@mail.gmail.com
Whole thread Raw
Responses Re: How is this possible "publication does not exist"  (Dave Cramer <davecramer@gmail.com>)
List pgsql-hackers
The publication exists but for some reason the function can't find it

SELECT * FROM pg_logical_slot_get_binary_changes('debezium', NULL, NULL,'proto_version','1','publication_names','dbz_publication');
ERROR:  publication "dbz_publication" does not exist
CONTEXT:  slot "debezium", output plugin "pgoutput", in the change callback, associated LSN 0/307D8E8
postgres=# select * from pg_publication;
     pubname     | pubowner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate
-----------------+----------+--------------+-----------+-----------+-----------+-------------
 dbz_publication |       10 | t            | t         | t         | t         | t
(1 row)

postgres=# SELECT * FROM pg_logical_slot_get_binary_changes('debezium', NULL, NULL,'proto_version','1','publication_names','dbz_publication');
ERROR:  publication "dbz_publication" does not exist
CONTEXT:  slot "debezium", output plugin "pgoutput", in the change callback, associated LSN 0/307D8E8

Dave Cramer

pgsql-hackers by date:

Previous
From: Ranier Vilela
Date:
Subject: RE: [PATCH] Remove twice assignment with var pageop (nbtree.c).
Next
From: Robert Haas
Date:
Subject: Re: WIP/PoC for parallel backup