Is pgsql threadsafe?

Lists: Postg젠 토토SQL : Postg젠 토토SQL 메일 링리스트 : 2008-03-13 이후 PGSQL-PHP 23:21
From: "William Temperley" <willtemperley(at)gmail(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: Is pgsql threadsafe?
Date: 2008-03-13 23:21:33
Message-ID: 439dc11e0803131621u5b7f7c62n6967cd5ad3354f95@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: Postg젠 토토SQL : Postg젠 토토SQL 메일 링리스트 : 2008-03-13 이후 PGSQL-PHP 23:21

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

From: Chris <dmagick(at)gmail(dot)com>
To: William Temperley <willtemperley(at)gmail(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: Is pgsql threadsafe?
Date: 2008-03-14 00:10:58
Message-ID: 47D9C292.6030901@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: 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/