Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group