On Fri, Sep 18, 2026 at 8:20 AM Peter Smith <[email protected]> wrote: > > AFAICT, the patch has traded one kind of quoting problem for another. > > Before patch v3, the message might show nested quotes. > > After patch v3, the message might show mismatched quotes: > CREATE PUBLICATION testpub9 FOR ALL TABLES EXCEPT (TABLE "schema has > embedded "" quotes"."part has embedded "" quotes"); > ERROR: cannot specify relation "schema has embedded " quotes.part has > embedded " quotes" in the publication EXCEPT clause >
This is not a problem but a general behavior in other cases as well. For example, see few: 1. postgres=# CREATE TABLE "a""b"(x int); CREATE TABLE postgres=# CREATE TABLE "a""b"(x int); ERROR: relation "a"b" already exists Notice that the ERROR message contains single embedded quotes whereas while specifying object there were double-quotes. 2. postgres=# ALTER TABLE "a""b" ADD COLUMN y int; ERROR: relation "a"b" does not exist Here also the behavior is the same as in previous example pg_class also shows this table with single quotes as follows: 16462 | a"b -- With Regards, Amit Kapila.
