fix for parameterized queries in DECLARE CURSOR statements

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: fix for parameterized queries in DECLARE CURSOR statements
Date: 2004-07-26 11:42:25
Message-ID: 4104EE21.4040504@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Here's a patch that allows parameterized queries to be used in a DECLARE
CURSOR statement.

Previously, the DECLARE would succeed but any FETCHes would fail as the
parameter values supplied to DECLARE were not propagated to the portal
it created. This patch adds that propagation. See
http://archives.postgresql.org/pgsql-hackers/2004-07/msg01047.php for
discussion.

I've tested the V3 protocol and SQL function paths by hand. The SPI path
hasn't been specifically tested but the regression tests appear happy.

-O

Attachment Content-Type Size
pgsql-server-parameterized-declare.txt text/plain 22.2 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Dunstan 2004-07-26 13:41:09 Re: pg_config
Previous Message Dave Page 2004-07-26 07:58:27 Re: [HACKERS] Function to kill backend