pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedFrom: Michael Meskes <meskes@postgresql.org>
To: Haszlakiewicz, Eric <EHASZLA@transunion.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: deallocating prepared statements
Date: Wed, 3 Dec 2008 15:12:55 +0100
Message-ID: <20081203141255.GA1874@feivel.credativ.de> (raw)
In-Reply-To: <9D29FD18CBD74A478CBA86E6EF6DBAD402FF8CC9@CHI4EVS04.corp.transunion.com>
References: <9D29FD18CBD74A478CBA86E6EF6DBAD402FF8CC9@CHI4EVS04.corp.transunion.com>
On Tue, Dec 02, 2008 at 01:22:46PM -0600, Haszlakiewicz, Eric wrote:
> figure out how to deallocate prepared statements. I tried using esql to
> do it (since the docs say that "it is only for use in embedded sql"):
>
> exec sql begin declare section;
> const char *stmtName = "exec_stmt";
> exec sql end declare section;
> exec sql deallocate :stmtName;
This will not work unless you do more in ECPG. Without preparing a statement,
having a connection etc. there is no way to deallocate the statement.
If you mix libpq and ecpg you should know what you do.
Michael
--
Michael Meskes
Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
Michael at BorussiaFan dot De, Meskes at (Debian|Postgresql) dot Org
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!
view thread (8+ messages) latest in thread
Message-ID: <20081203141255.GA1874@feivel.credativ.de>
Permalink: ../20081203141255.GA1874@feivel.credativ.de/
Also on: postgresql.org/message-id/20081203141255.GA1874@feivel.credativ.de
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: meskes@postgresql.org, EHASZLA@transunion.com
Subject: Re: deallocating prepared statements
In-Reply-To: <20081203141255.GA1874@feivel.credativ.de>
* 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