Re: [SQL] lo_export and files permissions
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 --- [EMAIL PROTECTED] wrote: > De: Mike Baroukh <[EMAIL PROTECTED]> > À: <[EMAIL PROTECTED]> > 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/
Re: [SQL] Help on some SQL command...
Hi, You can specify a default value for the create_date column like: create_date timestamp default 'now' In the insert statement just ommit that field and you will get the default, as insert into test1 (id, name) values (1, 'xxx'); Regards, -- Guo Bin --- Ang Sei Heng <[EMAIL PROTECTED]> wrote: > Hello to all the SQL gurus... > > I have this little table: > > test1 ( > id char(8) primary key, > name char(20), > create_date timestamp > ); > > Now, the create_date need to be updated > to date and time whenever id is being > inserted or updated. > > Is there a way in SQL that I can do this > automatically? __ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/
