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