From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | floating point exception! with contrib/xml |
Date: | 2003-04-17 12:11:35 |
Message-ID: | 200304171741.35872.mallah@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Dear All,
postmaster gives error when pgxml_xpath or
pgxml_parse is called more than once for
parsing the XML file that i am attaching.
When i run pgxml_parse first time it returns
true indicating that the parsing was successful.
When the same select is done second time the postmaster
gives error.
Eg
SELECT pgxml_xpath(xml,'//Company/Profile/Info/p/text()' , '','') ,
company_id from companies where company_id=43;
works fine first time but second time in same session
SELECT pgxml_xpath(xml,'//Company/Profile/Info/p/text()' , '','') ,company_id
from companies where company_id=42;
ERROR: floating point exception! The last floating point operation either exceeded
legal ranges or was a divide by zero
When i started writing this mail it was actually crashing the postmaster,
but now it is raising ERROR (bit more graceful ;-)
Regds
maLlah.
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
Attachment | Content-Type | Size |
---|---|---|
company_43.xml | text/xml | 13.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | codeWarrior | 2003-04-17 14:31:17 | Re: GRANT on all tables? |
Previous Message | Greg Kelley | 2003-04-17 11:26:15 | Require Assistance Solving Problem - erroneous pg_hba.conf |