Re: Question about xmloption and pg_restore

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