Re: Postgres 7.4 : ECPG not Thread-safe

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Michael Meskes <meskes(at)postgresql(dot)org>
Cc: Thierry Missimilly <THIERRY(dot)MISSIMILLY(at)BULL(dot)NET>, postgres general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres 7.4 : ECPG not Thread-safe
Date: 2003-10-12 20:30:49
Message-ID: 200310122030.h9CKUna03919@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I am going to see if I can reproduce the hang.

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

Michael Meskes wrote:
> On Thu, Oct 09, 2003 at 04:42:18PM +0200, Thierry Missimilly wrote:
> > I don't know if it is really link to Postgres and ECPG but if you
> > modifiy pgbch.pgc in the way that the
> > transaction is limited to "BEGIN; END; ", it will never hang.
>
> Do you mean it only hangs if you do automatic transaction starting? I
> mean if you use PGSQL implicit transactions and explicit BEGIN...END
> blocks it works well, but if you let libecpg start the transaction and
> just do a COMMIT every once in a while it is not?
>
> > Well, i'm not an expert in Linux multi-thread, but it seems the thread
>
> Neither am I, so I have no idea where to look.
>
> Michael
> --
> Michael Meskes
> Email: Michael at Fam-Meskes dot De
> ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes(at)jabber(dot)org
> Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
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-general by date

  From Date Subject
Next Message Josh Berkus 2003-10-12 20:31:42 Re: go for a script! / ex: PostgreSQL vs. MySQL
Previous Message Josh Berkus 2003-10-12 20:30:45 Re: go for a script! / ex: PostgreSQL vs. MySQL