X-Original-To: pgsql-php-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 8EC8D9FB3B5 for ; Thu, 31 Aug 2006 06:51:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 45128-08 for ; Thu, 31 Aug 2006 09:51:35 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web55206.mail.re4.yahoo.com (web55206.mail.re4.yahoo.com [206.190.58.170]) by postgresql.org (Postfix) with SMTP id 641479FB374 for ; Thu, 31 Aug 2006 06:51:35 -0300 (ADT) Received: (qmail 80188 invoked by uid 60001); 31 Aug 2006 09:51:34 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=nJR741d00CniD27mHWBZgi/A3KFmuiJfrfxnutaPeN0sV4SJ0MVVFuA6+oggigN6/zUE1ihh952Pe6YYIt+GH9yknOuQIQLwA5AZPAKffaibJevpGMkBchh5g4KCqr9DK+70l1e3XiWBrATWGKcV/hoWrHS/a34Vvdtlov2yv6o= ; Message-ID: <20060831095134.80186.qmail@web55206.mail.re4.yahoo.com> Received: from [72.134.0.217] by web55206.mail.re4.yahoo.com via HTTP; Thu, 31 Aug 2006 02:51:34 PDT Date: Thu, 31 Aug 2006 02:51:34 -0700 (PDT) From: babak badaei Reply-To: babak badaei Subject: Fw: Postgres 8.1.4 + PHP, hangs when querying more than 16 records! To: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.355 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: *** X-Archive-Number: 200608/21 X-Sequence-Number: 3592 In addition to below; I compile postgres 7.4.12. Same thing!!! More than 16 records hangs! ----- Forwarded Message ---- From: babak badaei To: pgsql-php@postgresql.org Sent: Wednesday, August 30, 2006 11:25:58 PM Subject: Postgres 8.1.4 + PHP, hangs when querying more than 16 records! OS: Fedora Core 5 PHP: PHP 5.1.4, PHP 5.1.6, and PHP 4.4.4 (compiled with --with-pgsql and install as binaries using YUM) Postgres 8.1.4 This scripts works: --------------------------------------------------------------------------------- \n"; while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) { echo "\t\n"; foreach ($line as $col_value) { echo "\t\t$col_value\n"; } echo "\t\n"; } echo "\n"; // Free resultset pg_free_result($result); // Closing connection pg_close($dbconn); ?> --------------------------------------------------------------------------------- This script hangs: ----------------------------------------------------------------------------------- \n"; while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) { echo "\t\n"; foreach ($line as $col_value) { echo "\t\t$col_value\n"; } echo "\t\n"; } echo "\n"; // Free resultset pg_free_result($result); // Closing connection pg_close($dbconn); ?> ------------------------------------------------------------------------------------- The only difference is that in the first we limit to 16 records, in the latter, to 17 (and greater hangs as well). I tried with three different versions of PHP, as mentioned above (PHP 5.1.4, 5.1.6, & 4.4.4) from both Apache and from the command line. Attempted few times each when compiled versions and binary distributions via yum. All behave the same way. All hang above 17 records. Take care! Babak.