pg_fetch_array problem

Поиск
Список
Период
Сортировка
От Alexander Mueller-Koegler
Тема pg_fetch_array problem
Дата
Msg-id 3795928C.17047B68@student.tuwien.ac.at
обсуждение исходный текст
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Jonathan davis"
Дата:
Сообщение: how to add users in group
Следующее
От: "Jonathan davis"
Дата:
Сообщение: pb with pg_group