From: | Roy Walter <walt(at)brookhouse(dot)co(dot)uk> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | artacus(at)comcast(dot)net, pgsql-general(at)postgresql(dot)org |
Subject: | Re: XML import with DTD |
Date: | 2009-07-11 18:59:43 |
Message-ID: | 4A58E11F.9050500@brookhouse.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Doh! That's it. Thanks a million.
-- Roy
Tom Lane wrote:
> Roy Walter <walt(at)brookhouse(dot)co(dot)uk> writes:
>
>> This one does not:
>>
>
>
>> INSERT INTO wms_collection (docxml) VALUES (XMLPARSE(content(
>> '<?xml version="1.0" encoding="ISO-8859-1"?>
>> <!DOCTYPE publicwhip
>> [
>> <!ENTITY ndash "–">
>> <!ENTITY mdash "—">
>> ]>
>> <shop>
>> <product>Shoes</product>
>> </shop>')))
>>
>
> What I know about XML wouldn't fill a thimble, but shouldn't you say
> DOCUMENT not CONTENT if you are trying to provide a complete document?
> Doing that seems to make this work without error.
>
> The fine manual states near the bottom of 8.13.1
> http://www.postgresql.org/docs/8.4/static/datatype-xml.html
> that CONTENT is less restrictive than DOCUMENT, but at least for
> this specific point that seems not to be true.
>
> regards, tom lane
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.387 / Virus Database: 270.13.10/2231 - Release Date: 07/11/09 05:57:00
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Gearon | 2009-07-11 21:46:20 | |
Previous Message | Richard Broersma | 2009-07-11 18:56:13 | LAPUG Social - Tuesday Evening July 14 |