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

~

PSA a v3 top-up patch to address the new problem.

Of course, putting my escape_embedded_quotes() function where I did in
the top-up doesn't seem appropriate. It would be better to associate
that with the original RelationGetQualifiedRelationName() and call it
from there, but RelationGetQualifiedRelationName was removed, so...

======
Kind Regards,
Peter Smith.
Fujitsu Australia

Attachment: PS_topup_fix_v3.diff
Description: Binary data

Reply via email to