2011/8/19 Shigeru Hanada <shigeru.hanada@gmail.com>:
> BTW, I noticed that pg_dump has same issue since 8.4, initial release of
> SQL/MED infrastructure. If a FDW option was defined on any FDW object
> with a name which contains one of special characters such as space and
> parentheses, pg_dump generates invalid OPTIONS clause such as "OPTIONS
> (separated name 'value')".
> ~~~~~~~~~~~~~~
> Perhaps this issue has been overlooked because dblink is practically the
> only use case of FDW option before 9.1. Since 9.1, users might get
> various FDW and some of those might use special characters in option
> name. ISTM that this fix should be back-patched, at least to 9.1.
> Please find attached patches for each STABLE branch.
Good catch, committed.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company