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.