Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2AC462E007D for ; Thu, 13 Mar 2008 21:13:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 45357-02 for ; Thu, 13 Mar 2008 21:13:19 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.224]) by postgresql.org (Postfix) with ESMTP id B2B422E005B for ; Thu, 13 Mar 2008 21:13:26 -0300 (ADT) Received: by qb-out-0506.google.com with SMTP id o12so3141435qba.17 for ; Thu, 13 Mar 2008 17:13:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; bh=nEJ36MDLpLJAYe57iE7uMMkM0CMM1jP1rjWwK740VYI=; b=BtDQ8D64mfZjJeFaM3BYteUPEtn+muf7NrCYzk5grhRIjeJ64ich81XCZWEoHzucQ8HOdqz0EeU5RhQCnNKHBwctyykutF/YiVOzAvnR39kBJCdfsazzvwe0NgsBW2ySmP2ywy6rwZGKu87w+TlMITf4PHpRh2nNdB32ziQBRsA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=KGTvyKD0VoPqhCHuWxZLqpJeDbJecCww0Auw6QK+/5IrlgFSzb360AGdD1MnUkVEbLQjxbYdqLJFAiOH1PirnliXYmDiiFjLzYw4av41VWilHkAgqav+0IjaRBo9X6EyWzPBMN6k7e5XBimaSCoTmkINpFsZbVByiWpHRk/y08Q= Received: by 10.114.156.1 with SMTP id d1mr10653455wae.120.1205453604723; Thu, 13 Mar 2008 17:13:24 -0700 (PDT) Received: from ?10.1.1.19? ( [203.217.18.65]) by mx.google.com with ESMTPS id j39sm27551643waf.32.2008.03.13.17.13.22 (version=TLSv1/SSLv3 cipher=RC4-MD5); Thu, 13 Mar 2008 17:13:24 -0700 (PDT) Message-ID: <47D9C292.6030901@gmail.com> Date: Fri, 14 Mar 2008 11:10:58 +1100 From: Chris User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: William Temperley CC: pgsql-php@postgresql.org Subject: Re: Is pgsql threadsafe? References: <439dc11e0803131621u5b7f7c62n6967cd5ad3354f95@mail.gmail.com> In-Reply-To: <439dc11e0803131621u5b7f7c62n6967cd5ad3354f95@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/15 X-Sequence-Number: 3840 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/