Thread: Re: Adding a Search Link ... (fwd)

Erk...I know *someone* was working on this...did we ever get anywhere on a
thread-safe libpq?  

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 

---------- Forwarded message ----------
Date: Thu, 06 Jan 2000 22:02:14 +0400
From: Alexander Barkov <bar@izhcom.ru>
To: The Hermit Hacker <scrappy@hub.org>
Subject: Re: Adding a Search Link ...

Hi again! I just have run to the shop to by some beer :-)
It is 10 PM here. 




The Hermit Hacker wrote:
> 
> that appears to do it...
> 
> now, how to enable the threading? :)
> 
> I added:
> 
> #define HAVE_PTHREAD 1
> 
> to config.h
> 

Don't edit config.h!

Just set up the environment variable CFLAGS with value "-pthread
-DHAVE_PTHREAD"

Then open main.c at line 238:

for(i=0;i<1;i++){

It is currently one thread, we did not implement yet a command line key
to set up
how many threads to start. Just write 2,3,4 for example. But I do not
currently
remember is libpq thread safe or not. I know definitly that mysql is
thread safe.



Then run configure and make.





-- 
Alexander Barkov
IZHCOM, Izhevsk
email:    bar@izhcom.ru      | http://www.izhcom.ru
Phone:    +7 (3412) 51-55-45 | Fax: +7 (3412) 78-70-10
ICQ:      7748759

The Hermit Hacker wrote:
> 
> Erk...I know *someone* was working on this...did we ever get anywhere on a
> thread-safe libpq?

Well, I don't think it has been fully documented, but the current libpq,
as long as you don't use one connect method, and use another --
apparently PQsetdbLogin IS threadsafe, as the AOLserver driver uses that
successfully. I THINK (I would search the archives, but.... Don Baccus
posted a question about just that at one point, and it was answered)
PQconnectdb is not, but don't quote me on that.

The short of it is that AOLserver, a multithreaded webserver,
successfully uses PQsetdbLogin -- which is apparently thread-safe.

Once the connection is established, libpq is apparently thread-safe. (at
least it is operating under a multithreaded webserver....)

--
Lamar Owen
WGCR Internet radio
1 Peter 4:11