Re: ODBC driver and refcursors

--- On Mon, 6/1/09, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> wrote:

> From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
> Subject: Re: [ODBC] ODBC driver and refcursors
> To: "Farooq" <shorrt_circuit(at)yahoo(dot)com>
> Cc: pgsql-odbc(at)postgresql(dot)org
> Date: Monday, June 1, 2009, 5:49 PM
> 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.
>

With two separate calls; the second statement complains that the cursor does not exist.

> I have the vague feeling the ODBC driver may have options
> that affect
> multi-statement queries.
>
>
> --
> Craig Ringer
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc
>