Thread

Re: Avoid corrupting DefElem nodes when parsing publication_names and publish options

sunil s <sunilfeb26@gmail.com> — 2025-12-24T11:42:36Z

Here is the reproduction of this issue.

As per the official documentation
<https://www.postgresql.org/docs/current/sql-createpublication.html>, creating
a publication with the following syntax will corrupt the option
list('insert, update, delete')

>  CREATE PUBLICATION mypublication FOR ALL TABLES WITH (publish ='insert,
update, delete');


By attaching a debugger to *parse_publication_options(), *we can verify
that the option list is modified after the call to
*splitIdentifierString().*

NOTE: Using double quotes (" "), the functionality works correctly.

Thanks & Regards,
Sunil S