Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id C258C65047F for ; Wed, 3 Dec 2008 10:20:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 02515-03-7 for ; Wed, 3 Dec 2008 10:20:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gauss.credativ.com (gauss.credativ.com [212.112.227.254]) by mail.postgresql.org (Postfix) with ESMTP id A3B826503EB for ; Wed, 3 Dec 2008 10:12:59 -0400 (AST) Received: from feivel (exit.credativ.com [87.139.82.80]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 13D0A77515; Wed, 3 Dec 2008 15:12:56 +0100 (CET) Received: by feivel (Postfix, from userid 1000) id B2676D6EE5; Wed, 3 Dec 2008 15:12:55 +0100 (CET) Date: Wed, 3 Dec 2008 15:12:55 +0100 From: Michael Meskes To: "Haszlakiewicz, Eric" Cc: pgsql-interfaces@postgresql.org Subject: Re: deallocating prepared statements Message-ID: <20081203141255.GA1874@feivel.credativ.de> Mail-Followup-To: "Haszlakiewicz, Eric" , pgsql-interfaces@postgresql.org References: <9D29FD18CBD74A478CBA86E6EF6DBAD402FF8CC9@CHI4EVS04.corp.transunion.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9D29FD18CBD74A478CBA86E6EF6DBAD402FF8CC9@CHI4EVS04.corp.transunion.com> User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/3 X-Sequence-Number: 6820 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!