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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
