Re: [BUGS] BUG #3244: problem with PREPARE

2007-04-27 Thread Tom Lane
"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

Re: [HACKERS] [BUGS] BUG #3244: problem with PREPARE

2007-04-24 Thread William Lawrance
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

Re: [BUGS] BUG #3244: problem with PREPARE

2007-04-24 Thread William Lawrance
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

Re: [HACKERS] [BUGS] BUG #3244: problem with PREPARE

2007-04-24 Thread Bruce Momjian
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

Re: [HACKERS] [BUGS] BUG #3244: problem with PREPARE

2007-04-24 Thread Michael Meskes
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

Re: [BUGS] BUG #3244: problem with PREPARE

2007-04-22 Thread Tom Lane
"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

[BUGS] BUG #3244: problem with PREPARE

2007-04-19 Thread William Lawrance
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