Received: from Donald.bks ([202.9.161.100]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f56DLhE23622 for ; Wed, 6 Jun 2001 09:21:44 -0400 (EDT) (envelope-from pnguruji@yahoo.com) Received: from Larry.bks (root@Larry.bks [200.2.1.10]) by Donald.bks (8.8.5/8.8.5) with ESMTP id SAA06255 for ; Wed, 6 Jun 2001 18:53:14 +0530 Received: from Larry.bks (guru@Larry.bks [200.2.1.10]) by Larry.bks (8.9.3/8.8.5) with ESMTP id SAA01250 for ; Wed, 6 Jun 2001 18:52:31 +0530 Date: Wed, 6 Jun 2001 18:52:31 +0530 (IST) From: Guru Prasad To: pgsql-sql@postgresql.org Subject: Large Objects - lo_export Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200106/60 X-Sequence-Number: 3273 Hi to list ! while running psql as 'postgres' user, i executed the following query. 'select lo_export(img.image, '/home/postgres/junk.tgz') from img where data = 'tar file'; The result of the above command is as follows. ERROR: lo_export: can't open unix file "/home/postgres/junk.tgz": Permission denied i performed the above query as superuser ('postgres'). I hope it' having all the superuser previleges. I am not sure why i am getting the above error. Any one got any clue for it. thanx in advance. guru. bk SYSTEMS (P) Ltd. P . N . G U R U P R A S A D -------------------------------------------------------------------------------