Re: BUG #1178: PQexecPrepared - PostgreSQL 7.4.1 - Mailing list pgsql-bugs

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> 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

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