From: | "Belbin, Peter" <PETER(dot)BELBIN(at)mcleodusa(dot)com> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | issue with xml functionality and <!DOCTYPE |
Date: | 2008-05-29 17:51:42 |
Message-ID: | 03FD38C1397A8C45AFC383CB4F1704FE290BFAFC43@MAILCLUSTER2.mcld.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce pgsql-general |
I'm hoping this is the right place to ask.
If not, please, kindly direct me to the right place.
I'm having an issue with xml functionality.
The issue is that the xml value has the following (large chunks have been removed, but this should be enough to demonstrate the issue):
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE workflow PUBLIC "-//OpenSymphony Group//DTD OSWorkflow 2.8//EN" "http://www.opensymphony.com/osworkflow/workflow_2_8.dtd">
<workflow>
<meta name="lastModified">Thu Feb 21 13:20:46 CST 2008</meta>
<meta name="generator">OSWorkflow Designer</meta>
</workflow>
When I try to get a list of the meta tag names with
set XML OPTION DOCUMENT;
select xpath('/workflow/meta/@name', workflow::xml) as thing1 from workflows where id = 3
I get the following message:
ERROR: could not parse XML data
DETAIL: Entity: line 2: parser error : StartTag: invalid element name
<!DOCTYPE workflow PUBLIC "-//OpenSymphony Group//DTD OSWorkflow 2.8//EN" "http:
^
********** Error **********
ERROR: could not parse XML data
SQL state: 2200M
Detail: Entity: line 2: parser error : StartTag: invalid element name
<!DOCTYPE workflow PUBLIC "-//OpenSymphony Group//DTD OSWorkflow 2.8//EN" "http:
^
The content of the text column is a valid xml document. The fragment starting with <!DOCTYPE is entirely valid. It shouldn't be making a fuss about this.
By the way, if I comment out (ie: wrap that 2nd line with <!-- -->), it seems to work just fine.
Please advise.
Regards,
Peter Belbin.
NOTICE: This electronic mail transmission may contain confidential information and is intended only for the person(s) named. Any use, copying, or disclosure by any other person is strictly prohibited. If you have received this transmission in error, please notify the sender via e-mail.
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2008-06-01 23:33:55 | == PostgreSQL Weekly News - June 01 2008 == |
Previous Message | David Fetter | 2008-05-26 05:15:21 | == PostgreSQL Weekly News - May 25 2008 == |
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2008-05-29 17:53:29 | Re: New MS patent: sounds like PG db rules |
Previous Message | Shane Ambler | 2008-05-29 17:37:17 | Re: New MS patent: sounds like PG db rules |