Re: Error: Input string was not in a correct format

From: "Rommel the iCeMAn" <icecrew(at)gmail(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Error: Input string was not in a correct format
Date: 2007-05-08 14:10:14
Message-ID: 003c01c7917a$a87906d0$b364a8c0@theport.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Louis-David Mitterrand 2007-05-09 12:55:20 query to select a linked list
Previous Message Reuven Abliyev 2007-05-08 14:00:25 Re: Needs Query