Re: Question about xmloption and pg_restore

2018-10-25 Thread Chapman Flack
On 10/25/18 05:02, Tom Lane wrote: > Chapman Flack writes: >> a difference between the 2003 SQL/XML standard (which PG implements) and >> the later versions, which changed the data model so there really is a >> containment relationship between 'content' and 'document'. >> https://wiki.postgresql.o

Re: Question about xmloption and pg_restore

2018-10-25 Thread Tom Lane
Chapman Flack writes: > On 05/18/18 15:50, Robert Haas wrote: >> Hmm. I thought that xmloption = 'content' was supposed to be strictly >> more permissive than xmloption = 'document'. > In the spirit of not leaving a good question hanging, this turns out to be > a difference between the 2003 SQL/

Re: Re: Question about xmloption and pg_restore

2018-10-24 Thread Chapman Flack
On 05/18/18 15:50, Robert Haas wrote: > On Thu, May 17, 2018 at 9:37 AM, Stefan Fercot > wrote: >> ERROR: invalid XML content >> DETAIL: line 1: StartTag: invalid element name >> http://mrcc.com/qgis.dtd' 'SYSTEM'> >> ^ >> CONTEXT: COPY layer_styles, line 1, column styleqml: "> 'http://mrcc.c

Re: Question about xmloption and pg_restore

2018-05-18 Thread Robert Haas
On Thu, May 17, 2018 at 9:37 AM, Stefan Fercot wrote: > When restoring a plain SQL dump, we got the message : > > ERROR: invalid XML content > DETAIL: line 1: StartTag: invalid element name > http://mrcc.com/qgis.dtd' 'SYSTEM'> > ^ > CONTEXT: COPY layer_styles, line 1, column styleqml: " 'http

Fwd: Question about xmloption and pg_restore

2018-05-17 Thread Stefan Fercot
Hi all, I've got some question about XML OPTION and pg_restore. In a xml type column are stored documents. When restoring a plain SQL dump, we got the message : /ERROR:  invalid XML content// //DETAIL:  line 1: StartTag: invalid element name// //http://mrcc.com/qgis.dtd' 'SYSTEM'>// // ^// //C