X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 36892D1B95A for ; Fri, 5 Sep 2003 13:25:17 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 36785-02 for ; Fri, 5 Sep 2003 10:24:48 -0300 (ADT) Received: from serdyn (7xxxx7.redshift.co.za [66.8.87.226]) by svr1.postgresql.org (Postfix) with SMTP id DB4B4D1BA13 for ; Fri, 5 Sep 2003 10:24:40 -0300 (ADT) X-Flags: 0000 Received: (qmail 20984 invoked by uid 65534); 5 Sep 2003 12:47:29 -0000 Received: from 215.commandprompt.com (EHLO hosting.commandprompt.com) (207.173.200.215) by mx0.gmx.net (mx015) with SMTP; 05 Sep 2003 14:47:29 +0200 Received: from postgresql.org (svr1.postgresql.org [64.117.224.193]) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id h85Ckr211214 for ; Fri, 5 Sep 2003 05:47:25 -0700 X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id C3B9AD1B8AE for ; Fri, 5 Sep 2003 12:40:47 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 29048-06 for ; Fri, 5 Sep 2003 09:40:19 -0300 (ADT) Received: from sccrmhc11.comcast.net (sccrmhc11.comcast.net [204.127.202.55]) by svr1.postgresql.org (Postfix) with ESMTP id 4D63ED1B897 for ; Fri, 5 Sep 2003 09:40:15 -0300 (ADT) Received: from bigbertha (h008019444478.ne.client2.attbi.com[24.60.19.116](untrusted sender)) by comcast.net (sccrmhc11) with SMTP id <2003090512401801100cd6ote>; Fri, 5 Sep 2003 12:40:18 +0000 Message-ID: <27970911.1062768128390.JavaMail.Administrator@serdyn> From: "Luis H" To: "Chris FR" , References: <2a584f81.0309020650.6457780e@posting.google.com> Subject: Re: Strange browser behavior when querying PostgreSql database Date: Fri, 5 Sep 2003 08:43:20 -0400 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 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Mailing-List: pgsql-php Precedence: bulk X-GMX-Antivirus: -1 (not scanned, may not use virus scanner) X-GMX-Antispam: 0 (Mail was not recognized as spam) X-fetched-from: gmx.net X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=BAYES_30, FORGED_MUA_OUTLOOK, QUOTED_EMAIL_TEXT, REFERENCES, X_MAILING_LIST X-Spam-Level: X-Archive-Number: 200309/19 X-Sequence-Number: 2296 Are you sure it freezes on the query? Could it be php code that uses the results from the query that hang the system? -L ----- Original Message ----- From: "Chris FR" To: Sent: Tuesday, September 02, 2003 10:50 AM Subject: [PHP] Strange browser behavior when querying PostgreSql database > Hi, > > I have a problem in a php script : > > when I execute it via Internet Explorer , sometimes the source is > complete (no problem), sometimes the source is incomplete (the html > page is cutted), and sometimes the browser doesn't display anything > and wait and wait and wait .... > > The problem comes from a request I peform in this PHP script : > > when I do the following request I have the problems quoted above : > > SELECT a.* FROM a WHERE a.idf = b.id > > I solved the problem by modifying the request : > > SELECT a.* FROM a, b WHERE a.idf = b.id > > Now the script works. > > But I don't understand why the first request causes those problems ? > > Is the first request has a correct syntax ? ( when submitted to > Postgres, there is no error message , and the results are displayed) > Is it due to PHP ? or PostgreSQL? > > > Thanks in advance, > > > Christophe Gras > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster