The following bug has been logged online:
Bug reference: 2556
Logged by: Jon Watte
Email address: pgfoundry.org@mindcontrol.org
PostgreSQL version: 7.3
Operating system: Linux 2.4
Description: ODBC driver version 2.00 doesn't publish functions
correctly
Details:
Define a function using pgAdmin III. Let's say we call it "next_id()" and
it's defined as "select max(id)+1 as next from sometable;".
In Data Sources view in Visual Studio 2005, "configure dataset" on a dataset
that connects to this database.
Notice that the function doesn't show up under "functions" but it does show
up under "stored procedures".
Check the stored procedure checkbox for the "next_id" function, to include
it in your data set view.
You will get an error from visual studio saying that the "next_id" stored
procedure wasn't actually found.
It seems to me as if the ODBC driver has some confusion as to whether it's a
function or a stored procedure, and this confusion means that Visual Studio
can't use it.