Thread: Re: [HACKERS] ECPG thread-safety
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/ --------------------------------------------------------------------------- Larry Rosenman wrote: > > > --On Friday, March 28, 2003 10:54:23 -0500 Bruce Momjian > <pgman@candle.pha.pa.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@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, Pennsylvania19073
I must have spent at least a day looking at configure threads tests the past few months. Look at the tests in Python, OpenLDAP, MySQL, Apache 2.0, Perl, ... each and everyone of them is different! Ouch. Way above my experience in configure. One of the packages (sorry cannot find my notes on which one!) I looked at down the test on a per-OS level - supplying the tread compile and link flags used on that OS and CC to see if they worked... Probably the simplest way to go? L. Bruce Momjian writes:> > Would someone take those patches and hunt around for proper 'configure'> tests? I can do the configurecoding, but I don't know what tests to> make.> > http://services.csl.co.uk/postgresql/> > > --------------------------------------------------------------------------->> Larry Rosenman wrote:> > > > > > --On Friday,March 28, 2003 10:54:23 -0500 Bruce Momjian > > <pgman@candle.pha.pa.us> wrote:> > > > >> > > I have the libpq patchin my mailbox that just needs configure thread> > > testing code. I will get that in for 7.4.> > I can help with theUnixWare threads stuff. Also, Micheal Meskes now has > > an account> > on my UnixWare box.> > > > The threads are nativeon 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/> > >>> > >> alongwith 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 completethis.> > >>> > >> 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 Capplication. 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 touse 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 listarchives?> > >> > > 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 SpringsDrive, 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
--On Friday, March 28, 2003 11:00:47 -0500 Bruce Momjian <pgman@candle.pha.pa.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@candle.pha.pa.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@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