PHP 4.0 Bug #7687: Another not a valid postgresql index
| From: | mrbig at sch dot bme dot hu | Date: | Tue, 07 Nov 2000 22:43:57 +0000 |
| Subject: | PHP 4.0 Bug #7687: Another not a valid postgresql index | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-37388@lists.php.net to get a copy of this message | ||
From: mrbig@sch.bme.hu
Operating system: Debian 2.2
PHP version: 4.0.3pl1
PHP Bug Type: PostgreSQL related
Bug description: Another not a valid postgresql index
Another the same problem, I've tried to write a script that cleanly reproduces what happened:
<?
$dblocation="localhost";
$dbname="mydb";
function TryHere () {
global $dblocation, $dbname;
$database=pg_Connect($dblocation,"","",$dbname);
$datein=pg_exec($database,"select datetime 'now';");
pg_Close($database);
$file=fopen('/tmp/some.file.txt','r');
if (pg_NumRows($datein)) {
$row=pg_Fetch_Array($datein,0);
echo "Date is: $row[0]<br>\n";
}
fclose($file);
#
# Everything worked fine
#
}
function TryHereAgain () {
global $dblocation, $dbname;
$database=pg_Connect($dblocation,"","",$dbname);
$datein=pg_exec($database,"select datetime 'now';");
pg_Close($database);
if (pg_NumRows($datein)) {
$row=pg_Fetch_Array($datein,0);
echo "Date is: $row[0]<br>\n";
}
#
# Mmm... Not anymore :(
#
}
TryHere();
TryHereAgain();
?>
If I ommit to open a file, or to use any of the pg_NumRows or pg_Fetch_Array at the first call of
the routine everything is ok. Also if I do the same things, but without functions. Quite
interesting...
--
Edit Bug report at: http://bugs.php.net/?id=7687&edit=1