X-Original-To: pgsql-interfaces@postgresql.org Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.189]) by postgresql.org (Postfix) with ESMTP id CBDAA474E44 for ; Fri, 21 Mar 2003 10:05:01 -0500 (EST) Received: from [212.227.126.155] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 18wO4n-0003uJ-00; Fri, 21 Mar 2003 16:04:57 +0100 Received: from [80.142.149.119] (helo=fam-meskes.de) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 18wO4m-0003Bj-00; Fri, 21 Mar 2003 16:04:57 +0100 Received: from feivel.fam-meskes.de (feivel.fam-meskes.de [172.26.14.7]) by fam-meskes.de (Postfix) with ESMTP id 8458110EF41; Fri, 21 Mar 2003 16:04:52 +0100 (CET) Received: by feivel.fam-meskes.de (Postfix, from userid 1000) id 0108785DD7; Fri, 21 Mar 2003 16:04:51 +0100 (CET) Date: Fri, 21 Mar 2003 16:04:51 +0100 From: Michael Meskes To: Bruce Momjian Cc: jiri.langr@konero.cz, PostgreSQL-interfaces Subject: Re: [BUGS] Bug #904: Deallocating of prepared statement in ECPG at Message-ID: <20030321150451.GA27690@feivel.fam-meskes.de> Mail-Followup-To: Bruce Momjian , jiri.langr@konero.cz, PostgreSQL-interfaces References: <20030227113519.37C69474E4F@postgresql.org> <200303192131.h2JLVcQ14766@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200303192131.h2JLVcQ14766@candle.pha.pa.us> User-Agent: Mutt/1.5.4i X-Archive-Number: 200303/116 X-Sequence-Number: 3865 > > When I prepare a statement in ECPG it lives only to first explicit transaction block. At the COMMIT it seems to be deallocated. Yes, it indeed is. I knew I found some docs stating it has to be. But since I cannot find them anymore I wonder what kind of docs it was. Very simple to fix. Just remove the call to ECPGdeallocate_all from ECPGtrans() in file ecpg/ecpglib/misc.c resp. ecpg/lib/misc.c. Michael -- Michael Meskes Email: Michael@Fam-Meskes.De ICQ: 179140304 Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!