Обсуждение: pgsql: Improve subscriber's error message for wrong publication relkind

Поиск
Список
Период
Сортировка

pgsql: Improve subscriber's error message for wrong publication relkind

От
Tom Lane
Дата:
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

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/e16db75dd6ba16d87f5bc05207b8739a3054b8fa

Modified Files
--------------
src/backend/replication/logical/tablesync.c | 21 +++++++++++++++++----
1 file changed, 17 insertions(+), 4 deletions(-)