On Fri, Sep 15, 2006 at 07:39:32AM +0000, Andy McCurdy wrote:
> result = PQprepare(conn, "MyQuery", "select * from pg_stat_activity", 0,
> 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.
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2006-09-16 13:28:40|
|Subject: Re: BUG #2629: libpq - Cannot deallocate prepared statement created with PQprepare() |
|Previous:||From: Magnus Hagander||Date: 2006-09-16 12:52:49|
|Subject: Re: BUG #2630: Can't unpack|