Igor Gavriloff <igor@nupes.cefetpr.br> writes:
> I'm trying to write an script in Perl5 that do an lo_import, but
> using the one that the perl interface offers returns an oid equal to
> zero:
> ...
> $conn = Pg::connectdb("dbname=test");
> $lobjId = $conn->lo_import($file);
lo_import, like all LO operations, has to be executed inside a
transaction block (BEGIN/END SQL commands). This is, um, poorly
documented in the Perl interface's docs, though you can read about
it in the docs for the underlying C library libpq.
regards, tom lane