The following bug has been logged online:

Bug reference: 1178
Logged by: Theo Kramer

Email address: theo (AT) flame (DOT) co.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...?


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
Case sensitivity. PQexecPrepared takes its name argument literally,
but anything inside a SQL command will get downcased unless quoted.
So you actually prepared "s0000123_000".

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

On Tue, 2004-06-22 at 19:23, Tom Lane wrote:
Many thanks - perhaps a gotcha in the documentation for PQexecPrepared()
would useful...

Regards
Theo


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly