pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Is pgsql threadsafe?
2+ messages / 2 participants
[nested] [flat]

* Is pgsql threadsafe?
@ 2008-03-13 23:21  William Temperley <willtemperley@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: William Temperley @ 2008-03-13 23:21 UTC (permalink / raw)
  To: pgsql-php

Hi all,

Last week I found the php_pgsql extension wouldn't work on IIS6,
windows server 2003, using php isapi. PHP was running fine, and I'm
99% certain the extension was loaded, extension_loaded() returned true
and a call to pg_connect produced no error messages, but no connection
either. No error messages were produced at all.
When the extension was not loaded I got the usual pg_connect()
undefined message.

I eventually got it running using fastcgi - which can run
non-threadsafe php on multithreaded web servers.

Is php_pgsql threadsafe?  Is this usual behaviour?  In which case I'm
going to abandon pgsql for pdo - I thought I was going to have to
rewrite my entire application about 3 days from the deadline 'til it
worked (hours of hair-tearing later) with fastcgi.

Thanks

Will



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Is pgsql threadsafe?
@ 2008-03-14 00:10  Chris <dmagick@gmail.com>
  parent: William Temperley <willtemperley@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Chris @ 2008-03-14 00:10 UTC (permalink / raw)
  To: William Temperley <willtemperley@gmail.com>; +Cc: pgsql-php

William Temperley wrote:
> Hi all,
> 
> Last week I found the php_pgsql extension wouldn't work on IIS6,
> windows server 2003, using php isapi. PHP was running fine, and I'm
> 99% certain the extension was loaded, extension_loaded() returned true
> and a call to pg_connect produced no error messages, but no connection
> either. No error messages were produced at all.
> When the extension was not loaded I got the usual pg_connect()
> undefined message.
> 
> I eventually got it running using fastcgi - which can run
> non-threadsafe php on multithreaded web servers.
> 
> Is php_pgsql threadsafe?  Is this usual behaviour?  In which case I'm
> going to abandon pgsql for pdo - I thought I was going to have to
> rewrite my entire application about 3 days from the deadline 'til it
> worked (hours of hair-tearing later) with fastcgi.

Probably a question better asked on the php-internals list (see 
http://www.php.net/mailing-lists.php) since they maintain the php-pgsql 
"module".

-- 
Postgresql & php tutorials
http://www.designmagick.com/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-03-14 00:10 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-13 23:21 Is pgsql threadsafe? William Temperley <willtemperley@gmail.com>
2008-03-14 00:10 ` Chris <dmagick@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox