On Thu, May 17, 2018 at 9:37 AM, Stefan Fercot <stefan.fer...@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
