[HACKERS] TR: Problems with Large Objects !!

Oops forgot to mention :

PostgreSQL version 6.1
Linux 2.0.30

and it worked 'correctly' with version 5.1

Thanks,

- -Yann-

- ----------
De :     Yann Courties
Date=A0:    jeudi 19 juin 1997 17:13
A :    'pgsql-hackers@postgreSQL.org'
Objet :    Problems with Large Objects !!

Hi,

I got a few problems with importing and exporting Large Object :

CREATE TABLE test (filename text, fileid oid);

INSERT INTO test (filename,fileid)=20
    VALUES( 'README', lo_import( '/home/postgres/README' ));

SELECT relname FROM pgclass; --> Freeze psql
SELECT * FROM test;    --> is OK

if I quit psql and then come back to it, it still has the same problem.
In fact the problem exists until I restart postmaster.
Then, after restarting posmaster, everything works fine and the file
README was 'correctly' imported.

Any suggestions ??

Regards,

- -Yann-=09

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