Re: ECPG thread-safety

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Lee Kindness <lkindness(at)csl(dot)co(dot)uk>, Philip Yarra <philip(at)utiba(dot)com>, pgsql-interfaces(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org, Michael Meskes <meskes(at)postgresql(dot)org>
Subject: Re: ECPG thread-safety
Date: 2003-03-28 16:10:34
Message-ID: 73950000.1048867834@lerlaptop.iadfw.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-interfaces pgsql-patches

--On Friday, March 28, 2003 11:00:47 -0500 Bruce Momjian
<pgman(at)candle(dot)pha(dot)pa(dot)us> 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
>> <pgman(at)candle(dot)pha(dot)pa(dot)us> 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(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
>> >
>> >
>> > ---------------------------(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(at)lerctr(dot)org
>> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
>>
>>
>>
>>
>
> --
> 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

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-03-28 16:12:24 Re: updateable cursors & visibility
Previous Message Bruce Momjian 2003-03-28 16:00:47 Re: ECPG thread-safety

Browse pgsql-interfaces by date

  From Date Subject
Next Message Lee Kindness 2003-03-28 16:15:08 Re: ECPG thread-safety
Previous Message Bruce Momjian 2003-03-28 16:00:47 Re: ECPG thread-safety

Browse pgsql-patches by date

  From Date Subject
Next Message Lee Kindness 2003-03-28 16:15:08 Re: ECPG thread-safety
Previous Message Bruce Momjian 2003-03-28 16:00:47 Re: ECPG thread-safety