Re: deallocating prepared statements

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: deallocating prepared statements
Date: 2008-12-03 21:01:02
Message-ID: e31a904f-4056-481d-9990-5f153bc59853@mm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Haszlakiewicz, Eric 2008-12-03 21:27:47 Re: deallocating prepared statements
Previous Message Haszlakiewicz, Eric 2008-12-03 17:45:53 Re: deallocating prepared statements