From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
---|---|
To: | Robert Nosko <robertn(at)eori(dot)net(dot)pl> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] lo_import() problem |
Date: | 1998-08-04 17:38:03 |
Message-ID: | Pine.LNX.3.96.980804183651.7573I-100000@maidast.retep.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 3 Aug 1998, Robert Nosko wrote:
> 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?
lo_import runs under the same userid as the postmaster (normally
postgres). If that user hasn't got access, then it will fail.
--
Peter T Mount peter(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)net
Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
From | Date | Subject | |
---|---|---|---|
Next Message | Krasnow, Greg | 1998-08-04 17:43:36 | float8 and default |
Previous Message | Peter T Mount | 1998-08-04 17:36:23 | Re: [GENERAL] How can i delete large objects from DB? |