From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Laurent Marzullo" <laurent(dot)marzullo(at)atosorigin(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PQexecParams and CURSOR |
Date: | 2005-01-17 15:59:56 |
Message-ID: | 2082.1105977596@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Laurent Marzullo" <laurent(dot)marzullo(at)atosorigin(dot)com> writes:
> Ok so here is the full TEST program I try to run:
I think you are running into an issue that was fixed during the 8.0
development cycle. From the CVS logs:
2004-08-01 21:30 tgl
Allow DECLARE CURSOR to take parameters from the portal in which it
is executed. Previously, the DECLARE would succeed but subsequent
FETCHes would fail since the parameter values supplied to DECLARE
were not propagated to the portal created for the cursor. In
support of this, add type Oids to ParamListInfo entries, which
seems like a good idea anyway since code that extracts a value can
double-check that it got the type of value it was expecting.
Oliver Jowett, with minor editorialization by Tom Lane.
So what you are trying to do will work in 8.0 but not in 7.4.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | John Cunningham | 2005-01-17 16:05:27 | Re: pgpool |
Previous Message | Tom Lane | 2005-01-17 15:53:08 | Re: What is postgresql doing for "statement: commit;begin;" |