Search Postgresql Archives

Re: PQexecParams and CURSOR

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux