#24804 [Opn->Fbk]: pg_lo_open() doesn't return a valid result ressource

From: Date: Tue, 11 Nov 2003 01:34:27 +0000
Subject: #24804 [Opn->Fbk]: pg_lo_open() doesn't return a valid result ressource
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-50214@lists.php.net to get a copy of this message 
 ID:               24804
 Updated by:       iliaa@php.net
 Reported By:      conni@php.net
-Status:           Open
+Status:           Feedback
 Bug Type:         PostgreSQL related
 Operating System: Win2000
 PHP Version:      4.3.2
 New Comment:

Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip




Previous Comments:
------------------------------------------------------------------------

[2003-09-03 12:19:20] conni@php.net

The operating system is Win2000.
There is no directory ext/pgsql/tests and no run_tests.php.

------------------------------------------------------------------------

[2003-08-01 06:08:55] sniper@php.net

No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.



------------------------------------------------------------------------

[2003-07-27 12:36:36] helly@php.net

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] conni@php.net

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

Thread (6 messages)

« previous php.bugs (#50214) next »