Re: blob

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]