Re: Importing blob

Поиск
Список
Период
Сортировка
От Patrick Nelson
Тема Re: Importing blob
Дата
Msg-id 4165C48DE9A0D211B6400800095C585F172DF8@WASHINGTON
обсуждение исходный текст
Ответ на Importing blob  (Patrick Nelson <pnelson@neatech.com>)
Список pgsql-general
Wow thanks all the replies got me thinking...

So I went to the server and put the file there in / dir and then went to my
client and tried the insert with /32334.jpg and darn it did work.  Then I
moved it to a dir (/home/sql) and played around a bit...

So it is actually the server that imports the file so it has to be on the
server.  Also, the directory (and subdirs) all have to have rx ability to
the PostgreSQL daemon user.  The file needs min r for the PostgreSQL daemon
user.

This is a bit confusing, wonder why a client wouldn't be able to insert a
blob?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: still lost: Cannot use more than 16 attributes in an
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: still lost: Cannot use more than 16 attributes in an index