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

Re: ODBC driver and refcursors

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Farooq <shorrt_circuit(at)yahoo(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC driver and refcursors
Date: 2009-06-01 12:49:08
Message-ID: 4A23CE44.6040804@postnewspapers.com.au (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2009-06-02 03:39:49
Subject: Re: ODBC driver and refcursors
Previous:From: FarooqDate: 2009-06-01 11:15:08
Subject: Re: ODBC driver and refcursors

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