Skip site navigation (1) Skip section navigation (2)

Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!

From: babak badaei <badaei(at)yahoo(dot)com>
To: Chris <dmagick(at)gmail(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!
Date: 2006-08-31 07:42:06
Message-ID: 20060831074206.42370.qmail@web55205.mail.re4.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-php
Hi Chris, Run through the native client everything works fine. I know, its really strange. Any ideas?

----- Original Message ----
From: Chris <dmagick(at)gmail(dot)com>
To: babak badaei <badaei(at)yahoo(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Sent: Wednesday, August 30, 2006 11:42:01 PM
Subject: Re: [PHP] Postgres 8.1.4 + PHP, hangs when querying more than 16 records!

babak badaei wrote:
> 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:
> ---------------------------------------------------------------------------------
> <?php
> // Connecting, selecting database
> $dbconn = pg_connect("host=localhost dbname=database user=web")
>    or die('Could not connect: ' . pg_last_error());
> 
> // Performing SQL query
> $query = 'SELECT * FROM foobar limit 16';

<snip>

>  // Performing SQL query
>  $query = 'SELECT * FROM foobar limit 17';

That seems really weird.

If you run those through psql natively what happens?

-- 
Postgresql & php tutorials
http://www.designmagick.com/




In response to

Responses

pgsql-php by date

Next:From: babak badaeiDate: 2006-08-31 09:51:34
Subject: Fw: Postgres 8.1.4 + PHP, hangs when querying more than 16 records!
Previous:From: ChrisDate: 2006-08-31 06:42:01
Subject: Re: Postgres 8.1.4 + PHP, hangs when querying more than 16

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group