Re: XML import with DTD

[Roy Walter <walt@xxxxxxxxxxxxxxxx>]

Doh! That's it. Thanks a million.

-- Roy

Tom Lane wrote:

Roy Walter <walt@xxxxxxxxxxxxxxxx> 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