Re: deallocating prepared statements

"Daniel Verite" <[email protected]> Wed, 03 Dec 2008 22:01:02 +0100
Newsgroups gmane.comp.db.postgresql.interfaces
Message-ID <e31a904f-4056-481d-9990-5f153bc59853@mm>
	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

-- 
Sent via pgsql-interfaces mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces