Ok, reading the PostgreSQL documentation on blobs helped :)
From what I can tell, there is no way to write a blob directly;
from a scalar; instead you have to use the lo_import and lo_export
methods with disk-based files, the way you are doing it now.
As much as MySQL gets picked on for not being a "real" RDBMS, it
seems a lot better suited for what you want to do here than PostgreSQL.
Re: Difficulty inserting a large object using DBD::Pg
Replies are listed 'Best First'.
We're back where we started! Thanks for giving it a
I'm not especially satisfied with pg's handling of large
objects, but I want transactions for this, so MySQL isn't
the way to go. I guess I'll just go with the pg-specific
route and hope that DBD::Pg 1.0 will offer a way to fake
normal lob handling.