Include schema-qualified names in publication error messages.

From: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Include schema-qualified names in publication error messages.
Date: 2026-04-28 11:03:34
Message-ID: CAFiTN-scG7b11Jsp+VoDRT8ZFE84eSKLcDsSB18dZ8AaP=R-mw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Previously, error messages in check_publication_add_relation() only
reported the relation name when a table could not be added to a
publication or included in an EXCEPT clause. This could be ambiguous
in databases where the same relation name exists in multiple schemas.

This patch updates these error messages to use schema-qualified names,
improving the clarity of error reporting for CREATE PUBLICATION and
ALTER PUBLICATION commands.

This has been discussed on another thread [1]

[1] https://www.postgresql.org/message-id/CAFiTN-u3Si2XJM9PW0xVsOSoVfTGJZZq-TirZb3eON4rqG1EFw%40mail.gmail.com

--
Regards,
Dilip Kumar
Google

Attachment Content-Type Size
v1-0001-Include-schema-qualified-names-in-publication-err.patch application/octet-stream 7.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2026-04-28 11:17:17 Re: Avoid orphaned objects dependencies, take 3
Previous Message Jakub Wartak 2026-04-28 11:01:51 Re: amcheck: add index-all-keys-match verification for B-Tree