ODBC driver and refcursors

Поиск
Список
Период
Сортировка
От Farooq
Тема ODBC driver and refcursors
Дата
Msg-id 687878.34500.qm@web45104.mail.sp1.yahoo.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Show max_identifier_length causes heavy query execution
Следующее
От: Moreno D.
Дата:
Сообщение: Re: Show max_identifier_length causes heavy query execution