X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7E445475E77; Fri, 28 Mar 2003 11:10:41 -0500 (EST) Received: from lerami.lerctr.org (lerami.lerctr.org [207.158.72.11]) by postgresql.org (Postfix) with ESMTP id 96CE547580B; Fri, 28 Mar 2003 11:10:40 -0500 (EST) Received: from lerlaptop.iadfw.net (lerlaptop.iadfw.net [206.66.13.21]) (authenticated bits=0) by lerami.lerctr.org (8.12.8/8.12.8/20030225) with ESMTP id h2SGAZfS003739; Fri, 28 Mar 2003 10:10:35 -0600 (CST) Date: Fri, 28 Mar 2003 10:10:34 -0600 From: Larry Rosenman To: Bruce Momjian Cc: Lee Kindness , Philip Yarra , pgsql-interfaces@postgresql.org, pgsql-hackers@postgresql.org, Michael Meskes Subject: Re: ECPG thread-safety Message-ID: <73950000.1048867834@lerlaptop.iadfw.net> In-Reply-To: <200303281600.h2SG0lP05298@candle.pha.pa.us> References: <200303281600.h2SG0lP05298@candle.pha.pa.us> X-Mailer: Mulberry/3.0.3 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Spam-Status: No, hits=-26.6 required=5.0 tests=BAYES_01,IN_REP_TO,QUOTED_EMAIL_TEXT,QUOTE_TWICE_1, REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/1153 X-Sequence-Number: 37399 --On Friday, March 28, 2003 11:00:47 -0500 Bruce Momjian wrote: > > Would someone take those patches and hunt around for proper 'configure' > tests? I can do the configure coding, but I don't know what tests to > make. > > http://services.csl.co.uk/postgresql/ I do know there are configure tests built for UnixWare's pthreads, but I don't know where. I have seen them invoked as I've compiled stuff. Also, once you compile a piece with -Kpthread you must compile ALL of it with -Kpthread. You are welcome to read the UnixWare docs at http://www.lerctr.org:8458/ or on the SCO site. > > > ------------------------------------------------------------------------- > -- > > Larry Rosenman wrote: >> >> >> --On Friday, March 28, 2003 10:54:23 -0500 Bruce Momjian >> wrote: >> >> > >> > I have the libpq patch in my mailbox that just needs configure thread >> > testing code. I will get that in for 7.4. >> I can help with the UnixWare threads stuff. Also, Micheal Meskes now >> has an account >> on my UnixWare box. >> >> The threads are native on UW, but you need to invoke the cc -Kpthread >> option. >> >> LER >> >> > >> > ---------------------------------------------------------------------- >> > --- -- >> > >> > Lee Kindness wrote: >> >> Philip, >> >> >> >> You can find the "patch so far" at: >> >> >> >> http://services.csl.co.uk/postgresql/ >> >> >> >> along with a libpq thread-safe patch. >> >> >> >> The thread referenced by Bruce's email details some of the issues >> >> still to be looked at. The main work is integration with the build >> >> system (testing for and linking in POSIX threads) and testing. >> >> >> >> I'm more than happy for you to look at at, I haven't had the time I >> >> hoped to complete this. >> >> >> >> Thanks, Lee. >> >> >> >> Philip Yarra writes: >> >> > As I found out recently, ECPG is not thread-safe. This is a problem >> >> > for us, as we really need to be able to use ECPG* in a >> >> > multi-threaded C application. Michael mentioned that Lee is >> >> > working on fixing these problems, but was not sure when it would >> >> > be complete. >> >> > >> >> > So, my questions are: >> >> > Lee/anyone, do you have an estimated completion date? >> >> > If not, can we (myself plus a "real" C programmer) help you? >> >> > >> >> > Regards, Philip Yarra. >> >> > >> >> > * Yes, we could use libpq, but ECPG minimises our porting from >> >> > Informix. Rewriting everything to use libpq would be too >> >> > expensive. >> >> > >> >> >> > >> > -- >> > Bruce Momjian | http://candle.pha.pa.us >> > pgman@candle.pha.pa.us | (610) 359-1001 >> > + If your life is a hard drive, | 13 Roberts Road >> > + Christ can be your backup. | Newtown Square, Pennsylvania >> > 19073 >> > >> > >> > ---------------------------(end of >> > broadcast)--------------------------- TIP 6: Have you searched our >> > list archives? >> > >> > http://archives.postgresql.org >> > >> >> >> >> -- >> Larry Rosenman http://www.lerctr.org/~ler >> Phone: +1 972-414-9812 E-Mail: ler@lerctr.org >> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 >> >> >> >> > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania > 19073 -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749