pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedFrom: Daniel Verite <daniel@manitou-mail.org>
To: pgsql-interfaces@postgresql.org
Subject: Re: deallocating prepared statements
Date: Wed, 03 Dec 2008 22:01:02 +0100
Message-ID: <e31a904f-4056-481d-9990-5f153bc59853@mm> (raw)
In-Reply-To: <9D29FD18CBD74A478CBA86E6EF6DBAD4030802AC@CHI4EVS04.corp.transunion.com>
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
view thread (8+ messages) latest in thread
Message-ID: <e31a904f-4056-481d-9990-5f153bc59853@mm>
Permalink: ../e31a904f-4056-481d-9990-5f153bc59853@mm/
Also on: postgresql.org/message-id/e31a904f-4056-481d-9990-5f153bc59853@mm
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: daniel@manitou-mail.org
Subject: Re: deallocating prepared statements
In-Reply-To: <e31a904f-4056-481d-9990-5f153bc59853@mm>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox