Thread: floating point exception! with contrib/xml

floating point exception! with contrib/xml

From
Rajesh Kumar Mallah
Date:
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