Re: BUG #1178: PQexecPrepared - PostgreSQL 7.4.1

On Tue, 2004-06-22 at 19:23, Tom Lane wrote:
> "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".
>

Many thanks - perhaps a gotcha in the documentation for PQexecPrepared()
would useful...

Regards
Theo