Thread: pg_fetch_array problem

Hello!

I am using RedHat Linux 6.0, Apache 1.3.4, PHP 3.0.11, PostgreSQL 6.5.1
and I have the following problem:
If I use the PHP3-functions pg_fetch_array or pg_fetch_object I get a
popup window saying
"The document contained no data" and my system log says
"Jul 21 10:17:44 smilie logger: pq_recvbuf: unexpected EOF on client
connection"

The PHP-File looks like this:
<?php
  $conn = pg_connect("host=localhost dbname=test");
  $query = "select * from test where nr=1");
  $res = pg_exec($conn, $query);
  $data = pg_fetch_array($res, 0);
  echo $data["nr"]."\n";
  pg_close($conn);
?>

The error message might be produced by
$INSTALL_DIR/src/backend/libpq/pqcomm.c, line 460

If I use pg_fetch_row instead of pg_fetch_array then I get the right
results without any errors.
<?php
  $conn = pg_connect("host=localhost dbname=test");
  $query = "select * from test where nr=1");
  $res = pg_exec($conn, $query);
  $data = pg_fetch_row($res, 0);
  echo $data[0]."\n";
  pg_close($conn);
?>

Does anybody encounter similar problems? Does anybody know how to solve
this problem? Can anybody tell me what I did wrong?
Please reply to my e-Mail-address.

Thanks, Alexander Mueller-Koegler
e9426332@student.tuwien.ac.at