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

ODBC driver and refcursors

From: Farooq <shorrt_circuit(at)yahoo(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: ODBC driver and refcursors
Date: 2009-05-28 05:25:56
Message-ID: 687878.34500.qm@web45104.mail.sp1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi Everyone,

I've been using 8.1 server and odbc driver with my
application on windows and it has been working fine. I
upgraded to 8.3.4 and started seeing issues with some of my
queries.

Here is the scenario:

create table users (userid int, username varchar(10));

insert into users values (1,'user1');
insert into users values (2,'user2');
insert into users values (3,'user3');
insert into users values (4,'user4');
insert into users values (5,'user5');

-- And I have functions similar to this

create or replace function test_cursor( refcursor, uid
int)
returns refcursor as
$$
BEGIN
      open $1 for

select userid, username
from  users
where userid >uid;

      return $1;
END;
$$
LANGUAGE 'plpgsql';

-- My application sends this query

select * from test_cursor('curs',3);
fetch all in "curs";

With 8.1 odbc driver, I get the below rows:

userid  |  username
--------------------
4    |  user4
5    |  user5

And with 8.3 odbc driver, I get

test_cursor
---------------
curs


The database server is the same with both drivers; what has changed
in the new odbc driver? Do I need to configure something
while creating the DSN?

Thanks for your help!

Regards,
Farooq



      


pgsql-odbc by date

Next:From: Moreno D.Date: 2009-05-28 13:42:52
Subject: Re: Show max_identifier_length causes heavy query execution
Previous:From: Albe LaurenzDate: 2009-05-27 07:16:58
Subject: Re: Show max_identifier_length causes heavy query execution

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