Hi Michael & Tom,
First of all, thanks to Michael for your response. I did enable logging of
SQL queries but still I could find no SQL statements in the logs. This led
me to believe it was a client-side error. Then I saw the response from Tom
which confirmed what I was thinking, so my second set o
"Rommel the iCeMAn" <[EMAIL PROTECTED]> 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
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
Ok guys,
Sorry for the false alarm. I solved the problem. When I define my parameters
in .NET in the order they are listed in pgAdmin, the function call works. If
I use the order that they are listed in Visual Studio's Server Explorer, the
function call fails. It appears Visual Studio's Server exp
Hi guys,
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
