pg_pconnect+PostgreSQL cursors

From: Sergei Levchenko <serg(at)city(dot)gov(dot)te(dot)ua>
To: pgsql-php(at)postgresql(dot)org
Subject: pg_pconnect+PostgreSQL cursors
Date: 2002-12-26 16:59:14
Message-ID: 20021226165914.GA8628@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 Christopher Kings-Lynne 2002-12-27 03:12:20 WebDB 0.6.0 Released
Previous Message Bruce Young 2002-12-26 15:45:03 Re: table not showing in explorer - Solved