Horton
Menu

Include schema-qualified names in publication error messages.

Dilip Kumar <dilipbalaut@gmail.com>

View thread
From: Dilip Kumar <dilipbalaut@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-04-28T11:03:34Z
Lists: pgsql-hackers

Attachments

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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Use schema-qualified names in EXCEPT clause error messages.