Received: from icebox.venux.net (icebox.venux.net [216.120.166.10]) by hub.org (8.10.1/8.11.0) with ESMTP id e9JG7gn65349 for ; Thu, 19 Oct 2000 12:07:42 -0400 (EDT) (envelope-from mitch@venux.net) Received: from doot (cx853045-b.phnx1.az.home.com [24.177.75.28]) by icebox.venux.net (Postfix) with SMTP id 952E826209 for ; Thu, 19 Oct 2000 12:17:06 -0400 (EDT) Message-ID: <012b01c039e7$4ba950f0$0200000a@doot> From: "Mitch Vincent" To: Subject: PostgreSQL troubles with 4.0.3pl1 Date: Thu, 19 Oct 2000 09:11:53 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 X-Archive-Number: 200010/37 X-Sequence-Number: 52 I've never had much trouble with PHP and PostgreSQL until this morning.. I was using persistent connections but started to have strange things happen with PHP when I used them, so I elected to go back to using plain old pg_connect(). I did and everything seemed to be working fine, then this morning I go and log into my application and on most of my queries I get something like Warning: 1 is not a valid PostgreSQL link resource in /usr/site/php/classes/db_pgsql.inc on line 64 Warning: 1 is not a valid PostgreSQL link resource in /usr/site/php/classes/db_pgsql.inc on line 67 So it seems that pg_connect isn't returning false and that's a good thing, still it seems the connection index is unusable.. I've stopped and restarted Apache and PostgreSQL, I even went so far as to reboot and ruin my impressive uptime to make sure everything that needed to be restarted got restarted... It's almost as if it's still trying to use persistent connections.. Has anyone seen this before? The problems with persistent connections wasn't noticeable until 4.0.3pl1 so it might be a problem there.. -Mitch "I'd change the world if God would just give me the source code."