floating point exception! with contrib/xml

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

Browse pgsql-admin by date

  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