BUG #2556: ODBC driver version 2.00 doesn't publish functions correctly

From: "Jon Watte" <pgfoundry(dot)org(at)mindcontrol(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2556: ODBC driver version 2.00 doesn't publish functions correctly
Date: 2006-07-29 15:44:11
Message-ID: 200607291544.k6TFiBs7042583@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2556
Logged by: Jon Watte
Email address: pgfoundry(dot)org(at)mindcontrol(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2006-07-30 01:41:23 Re: Fwd: Bug#380047: libpq-dev: no declaration for pg_encoding_to_char
Previous Message Martin Pitt 2006-07-29 10:33:40 Fwd: Bug#380047: libpq-dev: no declaration for pg_encoding_to_char