Horton

PQexecPrepared - PostgreSQL 7.4.1

Theo Kramer <theo@flame.co.za>

View thread
From: Theo Kramer <theo@flame.co.za>
To: psql-bugs@postgresql.org
Date: 2004-04-20T15:45:41Z
Lists: pgsql-bugs 
Hi

I am having a problem with PQexecPrepared() as follows (derived from
testlibpq3.c)

PQexec(conn, 
   "PREPARE S0000123_000 (text) AS SELECT * from test1 WHERE t = $1");

When invoking PQexecPrepared() I get the following message from the
backend

ERROR:  prepared statement "S0000123_0000" does not exist


Yet if I use 

PQexec(conn, "EXECUTE S0000123_0000 ('ho there')");

instead of PQexecPrepared() then all works perfectly.

Sounds like a bug to me...?

Regards
Theo