Re: [GENERAL] XML import with DTD

2009-07-11 Thread Roy Walter
Doh! That's it. Thanks a million. -- Roy Tom Lane wrote: Roy Walter writes: This one does not: INSERT INTO wms_collection (docxml) VALUES (XMLPARSE(content( ' ]> Shoes '))) What I know about XML wouldn't fill a thimble, but shouldn't you

Re: [GENERAL] XML import with DTD

2009-07-11 Thread Tom Lane
Roy Walter writes: > This one does not: > INSERT INTO wms_collection (docxml) VALUES (XMLPARSE(content( > ' > [ > > > ]> > > Shoes > '))) What I know about XML wouldn't fill a thimble, but shouldn't you say DOCUMENT not CONTENT if you are trying to pro

Re: [GENERAL] XML import with DTD

2009-07-11 Thread Roy Walter
rser error : StartTag: invalid element name -- Roy arta...@comcast.net wrote: Post a snippet of the xml and xpath you are trying to use. Scott - Original Message - From: "Roy Walter" To: pgsql-general@postgresql.org Sent: Friday, July 10, 2009 7:49:00 AM GMT -08:00 US/C

Re: [GENERAL] XML import with DTD

2009-07-10 Thread artacus
Post a snippet of the xml and xpath you are trying to use. Scott - Original Message - From: "Roy Walter" To: pgsql-general@postgresql.org Sent: Friday, July 10, 2009 7:49:00 AM GMT -08:00 US/Canada Pacific Subject: [GENERAL] XML import with DTD Hi I'm trying t

[GENERAL] XML import with DTD

2009-07-10 Thread Roy Walter
Hi I'm trying to use the XPath functionality of Postgres. I can populate a text field (unparsed) with XML data but as far as I can see the xpath() function [now] only works on the xml data type. When I try to populate a text field with XML data containing a DTD, however, the parser chokes. I