Re: [GENERAL] XML import with DTD

[Roy Walter]

Doh! That's it. Thanks a million.

-- Roy

Tom Lane wrote:

Roy Walter <w...@brookhouse.co.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   "&#8211;">
    <!ENTITY mdash   "&#8212;">
    ]>
    <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