pg_pconnect+PostgreSQL cursors

From: sector119(at)mail(dot)ru
To: pgsql-php(at)postgresql(dot)org
Subject: pg_pconnect+PostgreSQL cursors
Date: 2002-12-27 06:10:10
Message-ID: 20021227061010.GA20033@city.gov.te.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

Hi all

<?
$connection = pg_pconnect("dbname=$db user=$user password=$password");
if (!isset($page))
{
pg_exec($connection, "BEGIN WORK");
pg_exec($connection, "DECLARE all_data CURSOR FOR SELECT id,body FROM test")
}

$result = pg_exec($connection, "FETCH 1 FROM all_data");
$info = pg_fetch_array($result, 0);
print "|$info[0]|$info[1]|<br>\n";
?>

When I execute this script at first without page parameter I'v got data to info array! when I execute it at other times I'v got nothing :(

I've got closing of cursor and transaction! why??? I use permanent connection, why I've got closing of cursor and transaction!???

--
WBR, sector119

Responses

Browse pgsql-php by date

  From Date Subject
Next Message sector119 2002-12-27 09:09:02 pg_pconnect
Previous Message Christopher Kings-Lynne 2002-12-27 03:12:20 WebDB 0.6.0 Released