floating point exception! with contrib/xml - Mailing list pgsql-admin

From Rajesh Kumar Mallah
Subject floating point exception! with contrib/xml
Date
Msg-id 200304171741.35872.mallah@trade-india.com
Whole thread Raw
List 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

pgsql-admin by date:

Previous
From: "Greg Kelley"
Date:
Subject: Require Assistance Solving Problem - erroneous pg_hba.conf
Next
From: Tom Lane
Date:
Subject: Re: Require Assistance Solving Problem - erroneous pg_hba.conf