pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedlo_import
3+ messages / 2 participants
[nested] [flat]
* lo_import
@ 2003-05-05 08:35 Ramon Alonso Allende <allende@gredos.cnb.uam.es>
2003-05-05 11:12 ` Re: lo_import Nigel J. Andrews <nandrews@investsystems.co.uk>
0 siblings, 1 reply; 3+ messages in thread
From: Ramon Alonso Allende @ 2003-05-05 08:35 UTC (permalink / raw)
To: pgsql-interfaces
Hi I am using postgres 7.3 in macos X and i am not able to insert a
file into a table all i see is the following error
insert into archivo (d_id,path) values (1,
lo_import('/Users/allende/Documents/PDF/Networks/10356399.pdf'));
ERROR: lo_import: can't open unix file
"/Users/allende/Documents/PDF/Networks/10356399.pdf": Permission denied
I have done it as a regular user and as postgres user and still does
not work.
Any clue, please
R2A
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: lo_import
2003-05-05 08:35 lo_import Ramon Alonso Allende <allende@gredos.cnb.uam.es>
@ 2003-05-05 11:12 ` Nigel J. Andrews <nandrews@investsystems.co.uk>
2003-05-08 07:15 ` Re: lo_import Ramon Alonso Allende <allende@gredos.cnb.uam.es>
0 siblings, 1 reply; 3+ messages in thread
From: Nigel J. Andrews @ 2003-05-05 11:12 UTC (permalink / raw)
To: Ramon Alonso Allende <allende@gredos.cnb.uam.es>; +Cc: pgsql-interfaces
On Mon, 5 May 2003, Ramon Alonso Allende wrote:
> Hi I am using postgres 7.3 in macos X and i am not able to insert a
> file into a table all i see is the following error
>
> insert into archivo (d_id,path) values (1,
> lo_import('/Users/allende/Documents/PDF/Networks/10356399.pdf'));
>
> ERROR: lo_import: can't open unix file
> "/Users/allende/Documents/PDF/Networks/10356399.pdf": Permission denied
>
>
> I have done it as a regular user and as postgres user and still does
> not work.
But does the user the postmaster runs as have permission to read that file? I
would guess not. If you've looked at the file permissions and think it can then
also check the permissions on the directories leading to that file.
--
Nigel J. Andrews
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: lo_import
2003-05-05 08:35 lo_import Ramon Alonso Allende <allende@gredos.cnb.uam.es>
2003-05-05 11:12 ` Re: lo_import Nigel J. Andrews <nandrews@investsystems.co.uk>
@ 2003-05-08 07:15 ` Ramon Alonso Allende <allende@gredos.cnb.uam.es>
0 siblings, 0 replies; 3+ messages in thread
From: Ramon Alonso Allende @ 2003-05-08 07:15 UTC (permalink / raw)
To: Nigel J. Andrews <nandrews@investsystems.co.uk>; +Cc: pgsql-interfaces
Touche, the directory Documents did not have permissions.
thanks
R.
Nigel J. Andrews wrote:
> On Mon, 5 May 2003, Ramon Alonso Allende wrote:
>
>
>>Hi I am using postgres 7.3 in macos X and i am not able to insert a
>>file into a table all i see is the following error
>>
>>insert into archivo (d_id,path) values (1,
>>lo_import('/Users/allende/Documents/PDF/Networks/10356399.pdf'));
>>
>>ERROR: lo_import: can't open unix file
>>"/Users/allende/Documents/PDF/Networks/10356399.pdf": Permission denied
>>
>>
>>I have done it as a regular user and as postgres user and still does
>>not work.
>
>
> But does the user the postmaster runs as have permission to read that file? I
> would guess not. If you've looked at the file permissions and think it can then
> also check the permissions on the directories leading to that file.
>
>
--
Ramon Alonso-Allende Erhardt Tel: 91 585 46 76
Protein Design Group fax: 91 585 45 06
CNB/CSIC Campus U. Autonoma. Cantoblanco Madrid 28049
http://www.pdg.cnb.uam.es/allende/index.html
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-05-08 07:15 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-05 08:35 lo_import Ramon Alonso Allende <allende@gredos.cnb.uam.es>
2003-05-05 11:12 ` Nigel J. Andrews <nandrews@investsystems.co.uk>
2003-05-08 07:15 ` Ramon Alonso Allende <allende@gredos.cnb.uam.es>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox