The following bug has been logged online:
Bug reference: 1178
Logged by: Theo Kramer
Email address: theo(at)flame(dot)co(dot)za
PostgreSQL version: 7.4
Operating system: Redhat Linux 9
Description: PQexecPrepared - PostgreSQL 7.4.1
Details:
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...?