public inbox for [email protected]  
help / color / mirror / Atom feed
From: Amit Kapila <[email protected]>
To: [email protected]
Subject: pgsql: Use schema-qualified names in EXCEPT clause error messages.
Date: Fri, 08 May 2026 04:36:09 +0000
Message-ID: <[email protected]> (raw)

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 <[email protected]>
Author: vignesh C <[email protected]>
Reviewed-by: shveta malik <[email protected]>
Reviewed-by: Euler Taveira <[email protected]>
Reviewed-by: Amit Kapila <[email protected]>
Reviewed-by: Peter Smith <[email protected]>
Discussion: https://postgr.es/m/CAFiTN-scG7b11Jsp+VoDRT8ZFE84eSKLcDsSB18dZ8AaP=R-mw@mail.gmail.com

Branch
------
master

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

Modified Files
--------------
src/backend/catalog/pg_publication.c      | 17 ++++++++++++-----
src/backend/utils/adt/ruleutils.c         | 12 ++----------
src/backend/utils/cache/lsyscache.c       | 20 ++++++++++++++++++++
src/backend/utils/cache/relcache.c        | 10 ++++++++++
src/include/utils/lsyscache.h             |  1 +
src/include/utils/relcache.h              |  1 +
src/test/regress/expected/publication.out |  2 +-
7 files changed, 47 insertions(+), 16 deletions(-)



reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: pgsql: Use schema-qualified names in EXCEPT clause error messages.
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox