ID: 24804
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Open
+Status: Feedback
Bug Type: PostgreSQL related
Operating System: Win2000
PHP Version: 4.3.2
Previous Comments:
------------------------------------------------------------------------
[2003-07-27 12:36:36] [EMAIL PROTECTED]
Please follow the instructions in ext/pgsql/tests/Readme and execute
the following command using either CLI or CGI version of PHP:
php run-tests.php ext/pgsql
------------------------------------------------------------------------
[2003-07-25 12:05:17] [EMAIL PROTECTED]
Description:
------------
pg_lo_open() doesn't return a result ressource in php 4.3.2 whereas the
same script runs properly with PHP 4.3.1
Reproduce code:
---------------
<?php
include("lo_lib.php");
$sql = "select * from bilder";
$res = pg_query($sql);
$rows = pg_numrows($res);
for ($i=0;$i<$rows;$i++) {
$zeile = pg_fetch_array($res,$i);
echo 'Dateigroesse: '.$zeile["size"];
pg_query("begin");
$handle = pg_lo_open($zeile["bild"], "r"); echo '<br>handle =
'.$handle.'<br>';
if ($handle) {
$data = pg_loread($handle, 50000);
$len = strlen($data);
echo ' | gelesen: '.$len.' Bytes';
}
pg_loclose($handle);
pg_exec("commit");
...
Expected result:
----------------
Dateigroesse: 6038
handle = Resource id #6
| gelesen: 6038 Bytes | geschrieben: 6038 Bytes
This is the result from PHP 4.3.1
Actual result:
--------------
Dateigroesse: 6038
handle =
Warning: pg_loclose(): supplied argument is not a valid PostgreSQL
large object resource in c:\apache\htdocs\lotest\bildtest.php on line
19
This is the result from PHP 4.3.2
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24804&edit=1
