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

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/