On Thu, May 17, 2018 at 9:37 AM, Stefan Fercot <stefan.fercot@dalibo.com> wrote:
> When restoring a plain SQL dump, we got the message :
>
> ERROR: invalid XML content
> DETAIL: line 1: StartTag: invalid element name
> <!DOCTYPE qgis PUBLIC 'http://mrcc.com/qgis.dtd' 'SYSTEM'>
> ^
> CONTEXT: COPY layer_styles, line 1, column styleqml: "<!DOCTYPE qgis PUBLIC
> 'http://mrcc.com/qgis.dtd' 'SYSTEM'>
>
> Adding "SET XML OPTION DOCUMENT;" in top of the dump file allows to restore
> it.
Hmm. I thought that xmloption = 'content' was supposed to be strictly
more permissive than xmloption = 'document'.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company