From: Rommel the iCeMAn <icecrew@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Error: Input string was not in a correct format
Date: Tue, 8 May 2007 10:10:14 -0400
Message-ID: <003c01c7917a$a87906d0$b364a8c0@theport.com> (raw)
In-Reply-To: <20667.1178583085@sss.pgh.pa.us>
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 of thank-you's goes
out to Tom.
I declared a function as follows: test_func(integer, character varying,
integer, character varying). I used Visual Studio's Server Explorer to view
the function and it showed up as test_func(integer, integer, character
varying, character varying). The problem is that Server Explorer groups
parameters together according to data type. If you follow the function
declaration according to Server Explorer, you will end up with mismatched
parameters. If you follow the function declaration according to pgAdmin,
your code will work. From now on, at least until the problem in .NET is
fixed, I will be using pgAdmin to view my functions instead of Visual
Studio's Server Explorer.
FYI, I am using CoreLab's PostgreSQL.NET drivers, I've reported the issue to
them as well. At the time I didn't know if it was an issue with the .NET
drivers or with PostgreSQL so I reported my findings to this forum as well
as theirs.
Ok then, that's a mouthful, thanks again guys for the help.
Rommel Edwards,
Barbados, (sunny) Caribbean.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: icecrew@gmail.com
Subject: Re: Error: Input string was not in a correct format
In-Reply-To: <003c01c7917a$a87906d0$b364a8c0@theport.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox