Re: PQexecParams and CURSOR

On Mon, Jan 17, 2005 at 04:44:50PM +0100, Laurent Marzullo wrote:
> > >
> > >         // res = PQexec( conn , "FETCH 1 FROM MY_CURSOR" );
> >
> > The above should work if you uncomment it and comment out or remove
> > the other two attempts to execute FETCH.
>
> On my machine (2.6.7-gentoo-r9) and postgreSQL (postmaster --version) :
> 7.4.6
>
> the command above gave:
> FETCH failed: ERROR:  no value found for parameter 1

The problem appears to be in the 7.4.6 backend.  I did some tests
with 8.0.0rc5 and 7.4.6 and got the following results:

good    8.0.0rc5 backend, 8.0.0rc5 client
good    8.0.0rc5 backend, 7.4.6 client
bad    7.4.6 backend, 8.0.0rc5 client
bad    7.4.6 backend, 7.4.6 client

If I set log_error_verbosity to "verbose" then the 7.4.6 server
logs the following:

ERROR:  42704: no value found for parameter 1
LOCATION:  ExecEvalParam, execQual.c:518

I think the following message to pgsql-commiters announces the fix
that was applied to the development branch, which will soon be
released as 8.0.0:

http://archives.postgresql.org/pgsql-committers/2004-08/msg00028.php

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/