[ LUGOS ] Postgres, PHP in Large Objects

Aljaz Mavric aljaz.mavric na kiss.uni-lj.si
Ned Nov 21 17:11:56 CET 1999


Portam eno bazo iz MySql-a na Postgres.


$result = pgsqlquery ($f, "SELECT image FROM image WHERE idp = 'nekaj'
and stp='nekaj'");
$imgoid = pg_result ($result, 0, 0);
// ** uspesno dobim id objekta v bazi (do tu deluje)
// ** potem zelim odpreti ta objekt zu branje
$fd = pg_loopen($f,$imgoid,r);

pa zajoka :


Warning: Unable to open PostgresSQL large object in
/home/httpd/htdocs/pgultra/displayimage.php3 on line 21


int pg_loopen(int conn, int objoid, string mode);

pg_loopen() open an Inversion Large Object and returns file descriptor
of the large object. The file descriptor encapsulates
information about the connection. Do not close the connection before
closing the large object file descriptor. objoid specifies a
valid large object oid and mode can be either "r", "w", or "rw". Ni mi
jasno kaj bi bilo lahko narobe. Vsi parametri (vsaj po mejem mnenju so
podani pravilno)

Je ze kdo naletel na podoben problem ?

Lep pozdrav,

       Aljaz

P.S : iskanje po postgres arhivu liste ne vrne nic zanimivega razen eno
podobno vprasanje brez odgovora.




Dodatne informacije o seznamu Starilist