From: | Kynn Jones <kynnjo(at)gmail(dot)com> |
---|---|
To: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | DBD::Pg's $dbh->func( "/path/to/file", 'lo_import' ) fails silently |
Date: | 2009-03-18 16:00:30 |
Message-ID: | c2350ba40903180900n3743e5d9n63cfaaff484fe1d2@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to use Perl's DBD::Pg module to import a file as a large object.
For this I'm using the following:
my $oid = $dbh->func( "/absolute/path/to/file", 'lo_import' );
When I do this, a new record is added to pg_largeobject, with a
proper-looking non-null loid, but the data field remains empty, and the
variable $oid above gets a return value of undef, i.e. the call to func
fails. No error warning is ever emitted, as far as I can tell. ($dbh->errstr
returns undef.) FWIW, the file passed as the first argument is
world-readable, and the full path to it is world-accessible.
I've read the documentation for Perl's DBI and DBD::Pg modules, but I can't
find any information that will enable me to troubleshoot/debug this further.
Any suggestions would be greatly appreciated!
TIA!
Kynn
From | Date | Subject | |
---|---|---|---|
Next Message | Gurjeet Singh | 2009-03-18 16:19:14 | Re: schema, view and role |
Previous Message | Gurjeet Singh | 2009-03-18 15:54:20 | Re: sql transaction |