Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3B32D64FF2F for ; Wed, 3 Dec 2008 17:01:12 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 83890-08 for ; Wed, 3 Dec 2008 17:01:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-9404.dedibox.fr (sd-9404.dedibox.fr [88.191.51.144]) by mail.postgresql.org (Postfix) with ESMTP id 215A564FEBD for ; Wed, 3 Dec 2008 17:01:08 -0400 (AST) Received: by sd-9404.dedibox.fr (Postfix, from userid 1002) id 038C0E84004; Wed, 3 Dec 2008 22:01:05 +0100 (CET) Content-Type: text/plain; charset="iso-8859-15"; format=flowed Content-Disposition: inline Content-Transfer-Encoding: 7bit MIME-Version: 1.0 X-Mailer: Manitou v0.9.11 From: "Daniel Verite" Subject: Re: deallocating prepared statements To: pgsql-interfaces@postgresql.org In-Reply-To: <9D29FD18CBD74A478CBA86E6EF6DBAD4030802AC@CHI4EVS04.corp.transunion.com> Date: Wed, 03 Dec 2008 22:01:02 +0100 Message-ID: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/6 X-Sequence-Number: 6823 Haszlakiewicz, Eric wrote: > >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. I think the statement's name is an "identifier", just like a table or column name. So it has to follow the rules defined for identifiers in the "SQL syntax" chapter. Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org