Use schema-qualified names in EXCEPT clause error messages.
Amit Kapila <akapila@postgresql.org>
Use schema-qualified names in EXCEPT clause error messages. Error messages in check_publication_add_relation() previously reported only the relation name when a table in an EXCEPT clause could not be processed, which is ambiguous when the same name exists in multiple schemas. Use schema-qualified names instead, consistent with other error messages that reference relation names. Author: Dilip Kumar <dilipbalaut@gmail.com> Author: vignesh C <vignesh21@gmail.com> Reviewed-by: shveta malik <shveta.malik@gmail.com> Reviewed-by: Euler Taveira <euler@eulerto.com> Reviewed-by: Amit Kapila <amit.kapila16@gmail.com> Reviewed-by: Peter Smith <smithpb2250@gmail.com> Discussion: https://postgr.es/m/CAFiTN-scG7b11Jsp+VoDRT8ZFE84eSKLcDsSB18dZ8AaP=R-mw@mail.gmail.com
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/catalog/pg_publication.c | modified | +12 −5 |
| src/backend/utils/adt/ruleutils.c | modified | +2 −10 |
| src/backend/utils/cache/lsyscache.c | modified | +20 −0 |
| src/backend/utils/cache/relcache.c | modified | +10 −0 |
| src/include/utils/lsyscache.h | modified | +1 −0 |
| src/include/utils/relcache.h | modified | +1 −0 |
| src/test/regress/expected/publication.out | modified | +1 −1 |
Discussion
- Include schema-qualified names in publication error messages. 34 messages · 2026-04-28 → 2026-05-27