| From: | Patrick Nelson <pnelson(at)neatech(dot)com> |
|---|---|
| To: | "'PostgreSQL List (E-mail)'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Importing blob |
| Date: | 2002-08-07 17:15:43 |
| Message-ID: | 4165C48DE9A0D211B6400800095C585F172DF8@WASHINGTON |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2002-08-07 17:28:25 | Re: still lost: Cannot use more than 16 attributes in an index |
| Previous Message | Gerhard Hintermayer | 2002-08-07 16:54:10 | Re : Re: [Fwd: Tcl Interface modifications (Was: Re: database shutdown with persistent client connections)] |