"William Lawrance" <[EMAIL PROTECTED]> writes:
> This program that does "PQprepare" and then
> "PQexecPrepared" has worked previously, but doesn't
> work now. The error message is"
>ERROR: bind message supplies 1 parameters, but
> prepared statement "stmtopen" requires 0
I've ap
bject: Re: [HACKERS] [BUGS] BUG #3244: problem with PREPARE
On Mon, Apr 23, 2007 at 02:02:04PM -0700, William Lawrance wrote:
> Our first attempt to use the ECPG prepare interface revealed that ECPG
> doesn't use the PQlib prepare function. The ECPG prepare replaces any
> parameters wi
epared", using the array of parameters built
in the first step above.
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 22, 2007 7:53 PM
To: William Lawrance
Cc: pgsql-bugs@postgresql.org; [EMAIL PROTECTED]
Subject: Re: [BUGS] BUG
Michael Meskes wrote:
> On Mon, Apr 23, 2007 at 02:02:04PM -0700, William Lawrance wrote:
> > Our first attempt to use the ECPG prepare interface revealed that ECPG
> > doesn't use the PQlib prepare function. The ECPG prepare replaces any
> > parameters with their values and presents a new SQL stat
On Mon, Apr 23, 2007 at 02:02:04PM -0700, William Lawrance wrote:
> Our first attempt to use the ECPG prepare interface revealed that ECPG
> doesn't use the PQlib prepare function. The ECPG prepare replaces any
> parameters with their values and presents a new SQL statement to the
This is true and
"William Lawrance" <[EMAIL PROTECTED]> writes:
> This program that does "PQprepare" and then
> "PQexecPrepared" has worked previously, but doesn't
> work now.
> ...
> strcpy(openStmt, "declare C1 cursor for select cola"
>" from tprep"
>" where
The following bug has been logged online:
Bug reference: 3244
Logged by: William Lawrance
Email address: [EMAIL PROTECTED]
PostgreSQL version: cvs HEAD
Operating system: Linux
Description:problem with PREPARE
Details:
This program that does "PQprepare" and then
"P