Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B4BCC9FB627 for ; Mon, 7 May 2007 21:11:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 66218-09 for ; Mon, 7 May 2007 21:11:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 91BEB9FB5C0 for ; Mon, 7 May 2007 21:11:28 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l480BPQY020668; Mon, 7 May 2007 20:11:25 -0400 (EDT) To: "Rommel the iCeMAn" cc: pgsql-sql@postgresql.org Subject: Re: Error: Input string was not in a correct format In-reply-to: <000301c790fd$dd095350$b364a8c0@theport.com> References: <000301c790fd$dd095350$b364a8c0@theport.com> Comments: In-reply-to "Rommel the iCeMAn" message dated "Mon, 07 May 2007 19:17:09 -0400" Date: Mon, 07 May 2007 20:11:25 -0400 Message-ID: <20667.1178583085@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/51 X-Sequence-Number: 28332 "Rommel the iCeMAn" writes: > I'm trying to call a function from my .NET project and I am getting this > error: "Input string was not in a correct format". I have checked to make > sure that I am not mismatching my parameters. Is there a way that I can see > the actual SQL query that is being sent to postgresql? Once I can see this > then perhaps I can find the little gremlin that is annoying me :-) FWIW, I can't find that error string (or even one using the phrase "correct format") anywhere in the core PG code. So it's coming from somewhere on the client side, unless you've got some third-party library loaded into the backend. regards, tom lane