On Tue, 2004-06-22 at 19:23, Tom Lane wrote:
> "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".
>
Many thanks - perhaps a gotcha in the documentation for PQexecPrepared()
would useful...
Regards
Theo