Have you tried with a different client? In any case, you'll probably
get more help on pgsql-odbc.
On Jul 29, 2006, at 3:44 PM, Jon Watte wrote:
The following bug has been logged online:
Bug reference: 2556
Logged by: Jon Watte
Email address: [EMAIL PROTECTED]
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.
---------------------------(end of
broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED]
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
