"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)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