lo_import() problem

Поиск
Список
Период
Сортировка
От Robert Nosko
Тема lo_import() problem
Дата
Msg-id 003401bdbefa$976f5800$0577f4d4@eori.net.pl
обсуждение исходный текст
Ответы Re: [GENERAL] lo_import() problem  (Dustin Sallings <dustin@spy.net>)
Re: [GENERAL] lo_import() problem  (Peter T Mount <peter@retep.org.uk>)
Список pgsql-general
Hi,

I have a problem with built-in lo_import() function.
I want to store some images in my database, so I'm doing this:

create table image(name varchar, id oid);

Next, I want to import an image '1.jpg', which resides in '/home/username/postgres/images':

INSERT INTO image (name,id) VALUES('foo',lo_import('/home/username/postgres/images/1.jpg'));

I'm receiving something like this:
ERROR: be_lo_import - 'can't open unix file'

Why? I have full rights to database and graphics files in
'/home/username/postgres/images/'.
So, what's going on?
Please help...

regards,
robert



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

Предыдущее
От: "Sergei M. Suntsov"
Дата:
Сообщение: How can i delete large objects from DB?
Следующее
От: "Krasnow, Greg"
Дата:
Сообщение: default date