Re: XML import with DTD

[Tom Lane <tgl@xxxxxxxxxxxxx>]

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general