Re: [JDBC] Strange server error with current 8.0beta driver - Mailing list pgsql-hackers

From Barry Lind
Subject Re: [JDBC] Strange server error with current 8.0beta driver
Date
Msg-id 03E7D3E231BB7B4A915A6581D4296CC6CC97BF@NSNOVPS00411.nacio.xythos.com
Whole thread Raw
List pgsql-hackers
Oliver,

The patch works for me.  Thanks.  Things look good now against an 8.0
server.  (I still have a lot more testing to do though).

However I still have problems against a 7.4 server with the 8.0 jdbc
driver.  (ERROR: no value found for parameter 1).  You mentioned that
you had found this bug and fixed it in 8.0 of the server.  Any chance of
getting a backport?  Or is my only option to run with protocolVersion=2
on the jdbc connection.

Thanks,
--Barry


-----Original Message-----
From: Oliver Jowett [mailto:oliver@opencloud.com]
Sent: Wednesday, November 24, 2004 1:38 AM
To: Barry Lind
Cc: Tom Lane; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] [JDBC] Strange server error with current 8.0beta
driver

Oliver Jowett wrote:

> Perhaps PerformCursorOpen should copy the query tree before planning,
> or plan in a different memory context?

Patch attached. It moves query planning inside the new portal's memory
context. With this applied I can run Barry's testcase without errors,
and valgrind seems OK with it too.

-O



pgsql-hackers by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: Plperl Safe version check fails for Safe 2.09
Next
From: Mark Kirkwood
Date:
Subject: Re: MAX/MIN optimization via rewrite (plus query rewrites