Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8974A2E01B6 for ; Thu, 13 Mar 2008 20:21:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 18026-01 for ; Thu, 13 Mar 2008 20:21:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from hs-out-0708.google.com (hs-out-0708.google.com [64.233.178.243]) by postgresql.org (Postfix) with ESMTP id B3D072E0241 for ; Thu, 13 Mar 2008 20:21:34 -0300 (ADT) Received: by hs-out-0708.google.com with SMTP id x43so3290821hsb.3 for ; Thu, 13 Mar 2008 16:21:33 -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:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=FRFkUP7LJo+L501AXZ+WeyyjEOo2gFEIPR/1z9sK0VE=; b=usZIfejQyhLkEhnmsDldIk/+o63fj3x46ImjM9T4J5sSF3xmdb0jyW1XTSHrcdPR/ZMLOukwf9kalWbKjdnujXalRuCWRSOXh29rTdskreQsako5B3Rt/ltsHgQZDC4HU0OCD9FsWp7KDlqyk3Wx67tVOAGU1uepw4qLQuIe42o= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=N4Iovj07A2AWvV2KOfX6JKy9MUmRUmKNRnywp705zr4w+Os7qGEHn9nGtVo0Ls7KrOAFjAOtDKach/l7StK4b6ilk9YgEu6Eu+16maZWWwLR/aWEUHmzgH5WugOv2om6WCDqrFbU+GrYNJdDkHJSJE/OpDK5vgmecfL92IrRhx0= Received: by 10.100.41.16 with SMTP id o16mr20813123ano.73.1205450493666; Thu, 13 Mar 2008 16:21:33 -0700 (PDT) Received: by 10.100.247.6 with HTTP; Thu, 13 Mar 2008 16:21:33 -0700 (PDT) Message-ID: <439dc11e0803131621u5b7f7c62n6967cd5ad3354f95@mail.gmail.com> Date: Thu, 13 Mar 2008 23:21:33 +0000 From: "William Temperley" To: pgsql-php@postgresql.org Subject: Is pgsql threadsafe? MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/14 X-Sequence-Number: 3839 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