Skip site navigation (1) Skip section navigation (2)

Re: deallocating prepared statements

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: "Haszlakiewicz, Eric" <EHASZLA(at)transunion(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: deallocating prepared statements
Date: 2008-12-03 14:12:55
Message-ID: 20081203141255.GA1874@feivel.credativ.de (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)jabber(dot)org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!

In response to

Responses

pgsql-interfaces by date

Next:From: Haszlakiewicz, EricDate: 2008-12-03 17:38:27
Subject: Re: deallocating prepared statements
Previous:From: Daniel VeriteDate: 2008-12-03 11:29:05
Subject: Re: deallocating prepared statements

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group