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

Re: ODBC driver and refcursors

From: Farooq <shorrt_circuit(at)yahoo(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC driver and refcursors
Date: 2009-06-02 10:15:06
Message-ID: 12461.64474.qm@web45115.mail.sp1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc


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


      


Responses

pgsql-odbc by date

Next:From: FarooqDate: 2009-06-02 10:18:48
Subject: Re: ODBC driver and refcursors
Previous:From: Hiroshi InoueDate: 2009-06-02 03:39:49
Subject: Re: ODBC driver and refcursors

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