Re: [BUGS] Bug #904: Deallocating of prepared statement

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Michael Meskes <meskes(at)postgresql(dot)org>
Cc: jiri(dot)langr(at)konero(dot)cz, PostgreSQL-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: [BUGS] Bug #904: Deallocating of prepared statement
Date: 2003-03-21 15:32:46
Message-ID: 200303211532.h2LFWkc27894@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers pgsql-interfaces


This fix will appear in 7.4. Thanks for the report.

---------------------------------------------------------------------------

Michael Meskes wrote:
> > > 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(at)Fam-Meskes(dot)De
> ICQ: 179140304
> Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruno Wolff III 2003-03-21 20:15:37 Re: Security problem with Postgres sql
Previous Message Joe Conway 2003-03-21 15:16:15 Re: Bug #915: problem with returning setof with double precision

Browse pgsql-hackers by date

  From Date Subject
Next Message Christoph Haller 2003-03-21 15:33:09 Re: timestamp/date in ecpg
Previous Message Bruce Momjian 2003-03-21 15:18:16 Re: Nested transactions: low level stuff

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2003-03-21 15:49:54 Re: Roadmap for FE/BE protocol redesign
Previous Message Michael Meskes 2003-03-21 15:11:41 Re: Embedded C SQL Error -600