Re: BUG #2629: libpq - Cannot deallocate prepared statement created with PQprepare()

On Fri, Sep 15, 2006 at 07:39:32AM +0000, Andy McCurdy wrote:
> result = PQprepare(conn, "MyQuery", "select * from pg_stat_activity", 0,
> NULL);
>
> /*
> THE FOLLOW PQEXEC() FAILS.  Error message says:  ERROR:  prepared statement
> "myquery" does not exist"
> */
> result = PQexec(conn, "DEALLOCATE MyQuery");

You prepared a mixed-case identifier so you'll need to quote it in
SQL statements to preserve its case.  Unquoted identifiers are
folded to lowercase, as the error message shows.

result = PQexec(conn, "DEALLOCATE \"MyQuery\"");

See "Identifiers and Key Words" in the "SQL Syntax" chapter of the
documentation for more information about quoted identifiers.

http://www.postgresql.org/docs/8.1/interactive/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS

--
Michael Fuhr