Re: BUG #1178: PQexecPrepared - PostgreSQL 7.4.1

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