Received: from web218.mail.yahoo.com (web218.mail.yahoo.com [128.11.68.118]) by hub.org (8.10.1/8.10.1) with SMTP id e7G9VVn88713 for ; Wed, 16 Aug 2000 05:31:31 -0400 (EDT) Received: (qmail 5259 invoked by uid 60001); 16 Aug 2000 09:31:30 -0000 Message-ID: <20000816093130.5258.qmail@web218.mail.yahoo.com> Received: from [192.122.134.137] by web218.mail.yahoo.com; Wed, 16 Aug 2000 02:31:30 PDT Date: Wed, 16 Aug 2000 02:31:30 -0700 (PDT) From: Guo Bin Subject: Re: lo_export and files permissions To: mike.baroukh@netcourrier.com, pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200008/141 Hi, I was using sql lo_export function before upgraded to 7.0 (which doesn't allow non-admin to call it). So if possible, you can use the client function lo_export to extract the blob. I know it's simple in Perl DBI but not sure about java. Another work-around might be to lo_export the file to a directory writable by nobody. Regards, -- Guo Bin --- mike.baroukh@netcourrier.com wrote: > De: Mike Baroukh > À: > Objet: lo_export and files permissions > Date : lundi 14 août 2000 10:44 > > Hi everybody. > > Who can help me with a lo_export() problem ? : > > I'm using lo_export function in sql statement with pgsql > 6.5 on Linux RH 6.2. > Data are exported fine. > My problem is I can't delete created objects cause they > have writing permissions for user postgres only. > I tried changing umask for postmaster with no success. > When I try to delete, it's within a servlet so running as > user nobody.what would be fine is adding write > permissions to group postgres so I can add nobody to this > group ... > > Thanks in advance for your help. > > > Mike Baroukh > i-panema - 14 Rue Ballu Paris IXeme > 06 63 57 27 22 > > Mike Baroukh > i-panema - 10 rue Ballu - 75009 Paris > 06 63 57 27 22 > > ----- La messagerie itinérante sans abonnement > NetCourrier ----- > Web : www.netcourrier.com Minitel : 3615 et 3623 > NETCOURRIER > Tél : 08 36 69 00 21 __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/