Re: [JDBC] Strange server error with current 8.0beta driver

From: "Barry Lind" <blind(at)xythos(dot)com>
To: "Oliver Jowett" <oliver(at)opencloud(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [JDBC] Strange server error with current 8.0beta driver
Date: 2004-11-24 17:49:40
Message-ID: 03E7D3E231BB7B4A915A6581D4296CC6CC97BF@NSNOVPS00411.nacio.xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)opencloud(dot)com]
Sent: Wednesday, November 24, 2004 1:38 AM
To: Barry Lind
Cc: Tom Lane; pgsql-hackers(at)postgresql(dot)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

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2004-11-24 20:26:12 Re: MAX/MIN optimization via rewrite (plus query rewrites
Previous Message Andrew Dunstan 2004-11-24 17:29:19 Re: Plperl Safe version check fails for Safe 2.09