Re: deallocating prepared statements
"Haszlakiewicz, Eric" <[email protected]> Wed, 3 Dec 2008 11:45:53 -0600
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <9D29FD18CBD74A478CBA86E6EF6DBAD4030802AC@CHI4EVS04.corp.transunion.com> |
>From: [email protected] >[mailto:[email protected]] On Behalf Of >Daniel Verite > Haszlakiewicz, Eric wrote: >> dealloc_result = PQexecParams(conn, "DEALLOCATE $1", 1, deallocTypes, >> deallocValues, deallocLengths, deallocFormats, 1); >> >> But I get this error: >> syntax error at or near "$1" at character 12 > >The prepared statement's name is not a literal, and in general >parameterized queries don't accept parameters beyond literals. So you >need to insert the name directly into the SQL command text. > Well, that sucks. Now I need to worry about quoting and escaping. :( Is there a limit of what characters can be used in statement names? Neither the docs for PQprepare(), nor the docs for the prepare statement say anything about that. eric -- Sent via pgsql-interfaces mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-interfaces