Re: ODBC driver and refcursors - Mailing list pgsql-odbc

From Craig Ringer
Subject Re: ODBC driver and refcursors
Date
Msg-id 4A23CE44.6040804@postnewspapers.com.au
Whole thread Raw
In response to Re: ODBC driver and refcursors  (Farooq <shorrt_circuit@yahoo.com>)
List pgsql-odbc
Farooq wrote:

>> 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

Try dispatching this in two separate calls, instead of a single string
containing two semicolon-separated statements.

I have the vague feeling the ODBC driver may have options that affect
multi-statement queries.


--
Craig Ringer

pgsql-odbc by date:

Previous
From: Farooq
Date:
Subject: Re: ODBC driver and refcursors
Next
From: Hiroshi Inoue
Date:
Subject: Re: ODBC driver and refcursors