]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Improve subscriber's error message for wrong publication relkind.
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 15 Feb 2022 17:21:28 +0000 (12:21 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 15 Feb 2022 17:21:28 +0000 (12:21 -0500)
commitefae4401c4305ad5bcb05f803dc2576a4b346c8d
tree57d8970550dc4186f05cbfc3192f06bf964412d7
parent1cd5802ac69a1831b1a1c3b7c69dd99ae80f0b5b
Improve subscriber's error message for wrong publication relkind.

Pre-v13 versions only support logical replication from plain tables,
while v13 and later also allow partitioned tables to be published.
If you tried to subscribe an older server to such a publication,
you got "table XXX not found on publisher", which is pretty
unhelpful/confusing.  Arrange to deliver a more on-point error
message.  As commit c314c147c did in v13, remove the relkind check
from the query WHERE clause altogether, so that "not there"
is distinguishable from "wrong relkind".

Per report from Radoslav Nedyalkov.  Patch v10-v12.

Discussion: https://postgr.es/m/2952568.1644876730@sss.pgh.pa.us
src/backend/replication/logical/tablesync.c