[HACKERS] Problems with Large Objects !!

Поиск
Список
Период
Сортировка
От ycourties@internet.ubisoft.fr (Yann Courties)
Тема [HACKERS] Problems with Large Objects !!
Дата
Msg-id 96a3452860438ddbe763d04575fa6531
обсуждение исходный текст
Список 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-

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

В списке pgsql-hackers по дате отправления: