"PostgreSQL Bugs List" <[EMAIL PROTECTED]> 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". regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings