Обсуждение: blob
Hi, If this is the wrong group to post this question, please point me in the right direction, Now my problem. I've been trying to get large objects "happening" through a perl script, which I want to run by httpd (user nobody) from the cgi-bin directory. In other words, I want to serve images to browsers from a database. This includes using the 'lo_export' function. But I've found that I can only run 'lo_export' as superuser. Is there any other way to get images served from the database? Or how do I get around the above in perl. I understand that there is a client side lo_export in libpq, but that would mean writing my cgi script in c, yes? I think. If not how do I use the client side. Does that mean embedding my perl script in html? any suggestions? thanks greatly, viva postgres! Luke
On Mon, 8 Oct 2001, Luke wrote: > Now my problem. > I've been trying to get large objects "happening" through a perl script, > > which I want to run by httpd (user nobody) from the cgi-bin directory. > In other words, I want to serve images to browsers from a database. > This includes using the 'lo_export' function. > But I've found that I can only run 'lo_export' as superuser. > > Is there any other way to get images served from the database? > Or how do I get around the above in perl. Are you using DBD::Pg in your Perl script? You can use the lo interface via the func method of the DBI driver: $lob_fd = $dbh->func($lobId, $mode, "lo_open"); See the perldoc on DBD::Pg for more information on how to do this. The DBD::pg is built over libpq, so you should be able to export via this facility. -- Brett http://www.chapelperilous.net/ ------------------------------------------------------------------------ C'est magnifique, mais ce n'est pas l'Informatique. -- Bosquet [on seeing the IBM 4341]