Received: from localhost (maia-3.hub.org [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 229CE9FB8CA
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  7 May 2007 20:46:19 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 78495-08 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon,  7 May 2007 20:46:10 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from mtai04.charter.net (mtai04.charter.net [209.225.8.184])
	by postgresql.org (Postfix) with ESMTP id E53FF9FB741
	for <pgsql-sql@postgresql.org>; Mon,  7 May 2007 20:46:14 -0300 (ADT)
Received: from aa06.charter.net ([10.20.200.158]) by mtai04.charter.net
	(InterMail vM.7.08.02.00 201-2186-121-20061213) with ESMTP
	id <20070507234609.MYGR1421.mtai04.charter.net@aa06.charter.net>;
	Mon, 7 May 2007 19:46:09 -0400
Received: from [10.0.1.3] (really [66.188.171.178]) by aa06.charter.net
	with ESMTP id <20070507234609.YYIT6497.aa06.charter.net@[10.0.1.3]>;
	Mon, 7 May 2007 19:46:09 -0400
In-Reply-To: <000301c790fd$dd095350$b364a8c0@theport.com>
References: <000301c790fd$dd095350$b364a8c0@theport.com>
Mime-Version: 1.0 (Apple Message framework v752.2)
Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Message-Id: <0CAAE637-6249-47E9-AB46-11DB650E0902@seespotcode.net>
Cc: <pgsql-sql@postgresql.org>
Content-Transfer-Encoding: 7bit
From: Michael Glaesemann <grzm@seespotcode.net>
Subject: Re: Error: Input string was not in a correct format
Date: Mon, 7 May 2007 18:46:07 -0500
To: Rommel the iCeMAn <icecrew@gmail.com>
X-Mailer: Apple Mail (2.752.2)
X-Chzlrs: 0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200705/50
X-Sequence-Number: 28331


On May 7, 2007, at 18:17 , Rommel the iCeMAn wrote:

> Is there a way that I can see
> the actual SQL query that is being sent to postgresql?

 From within PostgreSQL you can put the SQL queries in the logs.

http://www.postgresql.org/docs/8.2/interactive/runtime-config- 
logging.html#RUNTIME-CONFIG-LOGGING-WHAT

Check out the log_statement paramenter (and possibly others).

You might also have some logging options within .NET, but as I'm  
unfamiliar with the framework, I really can't help you there.

Michael Glaesemann
grzm seespotcode net