[HACKERS] Problems with Large Objects !! - Mailing list pgsql-hackers

Hi,

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

CREATE TABLE test (filename text, fileid oid);

INSERT INTO test (filename,fileid)
    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-

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