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 "–"> > <!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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
