X-Original-To: pgsql-interfaces@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E842D47630B for ; Thu, 8 May 2003 03:15:54 -0400 (EDT) Received: from menta.ti.uam.es (menta.ti.uam.es [150.244.9.13]) by postgresql.org (Postfix) with ESMTP id 0F150475B8E for ; Thu, 8 May 2003 03:15:53 -0400 (EDT) Received: from frenadol.ti.uam.es (frenadol.ti.uam.es [150.244.9.89]) by menta.ti.uam.es (8.9.3/8.9.3/UAM) with ESMTP id JAA18628 for ; Thu, 8 May 2003 09:15:52 +0200 (MEST) Received: from embnet.cnb.uam.es (bossa-nova.cnb.uam.es [150.244.80.7]) by frenadol.ti.uam.es (8.12.8/8.11.3/UAM) with ESMTP id h487FpPq025541 for ; Thu, 8 May 2003 09:15:51 +0200 Received: from gredos.cnb.uam.es (fujiyama.cnb.uam.es [150.244.85.64]) by embnet.cnb.uam.es (8.10.1/8.10.1) with ESMTP id h487Fo210963901; Thu, 8 May 2003 09:15:50 +0200 (DST) Message-ID: <3EBA0426.7000001@gredos.cnb.uam.es> Date: Thu, 08 May 2003 09:15:50 +0200 From: Ramon Alonso Allende Organization: CNB-CSIC User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Nigel J. Andrews" Cc: pgsql-interfaces@postgresql.org Subject: Re: lo_import References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-38.8 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MOZILLA_UA autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/25 X-Sequence-Number: 4143 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