rosenk
Programmer
- Jan 16, 2003
- 403
I'm having a strange problem. I'm trying to get the contents of a large object for which I have an OID stored in a table. I successfully retrieve the OID (and confirm that the large object exists by using \lo_export on it from inside psql), but am getting a 0 return for the file descriptor when I make the call:
[tt]my $lobj_fd = $dbh->func($formOID, $dbh->{pg_INV_READ}, 'lo_open');[/tt]
This same code works for another large object with the OID stored in the same table as the one that's failing.
The only information that I could find indicates that there could be a problem if you do not work with large objects within a single transaction, but I am making sure that is the case.
Any ideas?
Thanks,
Keith
[tt]my $lobj_fd = $dbh->func($formOID, $dbh->{pg_INV_READ}, 'lo_open');[/tt]
This same code works for another large object with the OID stored in the same table as the one that's failing.
The only information that I could find indicates that there could be a problem if you do not work with large objects within a single transaction, but I am making sure that is the case.
Any ideas?
Thanks,
Keith