X-Original-To: pgsql-interfaces@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 983BC476141 for ; Mon, 5 May 2003 04:35:33 -0400 (EDT) Received: from menta.ti.uam.es (menta.ti.uam.es [150.244.9.13]) by postgresql.org (Postfix) with ESMTP id 16352475E91 for ; Mon, 5 May 2003 04:35:24 -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 KAA12168 for ; Mon, 5 May 2003 10:35:20 +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 h458ZJPo028712 for ; Mon, 5 May 2003 10:35:19 +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 h458ZJt10682426 for ; Mon, 5 May 2003 10:35:19 +0200 (DST) Message-ID: <3EB62247.50804@gredos.cnb.uam.es> Date: Mon, 05 May 2003 10:35:19 +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: pgsql-interfaces@postgresql.org Subject: lo_import Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-12.1 required=5.0 tests=BAYES_10,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/8 X-Sequence-Number: 4126 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