Thread

1. Re: Importing blob

   Patrick Nelson <pnelson@neatech.com> — 2002-08-07T17:15:43Z

   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?
   
   

2. Re: Importing blob

   Doug McNaught <doug@wireboard.com> — 2002-08-07T18:00:39Z

   Patrick Nelson <pnelson@neatech.com> writes:
   
   > 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.
   
   Yup.
   
   > This is a bit confusing, wonder why a client wouldn't be able to insert a
   > blob?
   
   You can, but you have to call the lo_import function in the *client*
   library, not the server-side function.  See the client library docs.
   Yes, it's slightly confusing until you figure it out.
   
   -Doug