X-Original-To: pgsql-interfaces@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id 3F312475A8D; Tue, 22 Apr 2003 00:13:56 -0400 (EDT)
Received: from cpc-gw2.cpc.net.au (unknown [210.9.248.93])
	by postgresql.org (Postfix) with ESMTP
	id 94156474E42; Tue, 22 Apr 2003 00:13:54 -0400 (EDT)
Received: from utiba.com (IDENT:root@ser1.cpc.net.au [192.168.0.19])
	by Utiba Mail Gateway (2.2.2) with ESMTP id h3M38ZP30234;
	Tue, 22 Apr 2003 13:08:35 +1000
Received: from Utiba Mail Thingy
	by utiba.com (Dunno/1.1.2) with ESMTP id OAA16959;
	Tue, 22 Apr 2003 14:13:39 +1000
Content-Type: text/plain;
  charset="iso-8859-1"
From: Philip Yarra <philip@utiba.com>
Organization: Utiba
To: Michael Meskes <meskes@postgresql.org>
Subject: Re: ECPG thread-safety
Date: Tue, 22 Apr 2003 14:05:33 +1000
User-Agent: KMail/1.4.1
Cc: pgsql-interfaces@postgresql.org,
	Bruce Momjian <pgman@candle.pha.pa.us>
References: <200303280200.h2S20N218363@candle.pha.pa.us>
	<200303281749.04746.philip@utiba.com>
In-Reply-To: <200303281749.04746.philip@utiba.com>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Message-Id: <200304221405.33040.philip@utiba.com>
X-Spam-Status: No, hits=-38.9 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT,
	REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_KMAIL
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/147
X-Sequence-Number: 4086

On Fri, 28 Mar 2003 17:49, Philip Yarra wrote:
> On Fri, 28 Mar 2003 13:00, you wrote:
> > I have put a mailbox file at:
> >
> > 	ftp://candle.pha.pa.us/pub/postgresql/mypatches
> >
> > where there is a partial implementation of thread-safe ecpg.  Maybe you
> > can work with Michael to complete it.
>
> Okay, thanks for that. Have grabbed the file, and started reading. I'll
> also wait to hear from Michael or Lee before going too far on this.

I've had a few tries at testing the ECPG threadsafe patch, but so far no lu=
ck,=20
probably due to my own lack of experience. Can someone help me out with how=
=20
to test this?=20

So far I have:
- run configure
- applied Lee's patch to the source tree for 7.3.2
- edited src/Makefile.global, adding -pthread to CFLAGS and and -lpthread t=
o=20
LIBS
- make and make install
- make our own pthread'd app, linking against newly installed pgsql
Then when I run our app with 3 DB threads, I can watch 2 of the threads fai=
l=20
to return from EXEC SQL, which is exactly the same behaviour we used to get.

Can anyone point me in the right direction? I'm building on RedHat Linux 7.=
3=20
on Intel, using all standard tools for that version (except updated bison=
=20
from 1.35 to 1.875). So gcc 2.96, gmake 3.79.1, etc. Let me know if more=20
details are required.

Regards, Philip Yarra.