Re: lo_import problems

Igor Gavriloff <igor(at)nupes(dot)cefetpr(dot)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