In case anyone else has experienced this problem as well,
here's an update of what I've learned since posting the
I spoke with H. Merijn Brand (author of DBD::Unify) at
the July Amsterdam.pm meeting to see if he had any
insights. According to him (and if this is wrong I
probably am remembering it incorrectly), large object
handling probably isn't implemented in the Postgres DBD
because DBI currently lacks the specifications for doing
so, which is the reason he did not implement large objects
in his own driver. According to the
section 5.2, the answer to 'How do I handle BLOB
data with DBI' is:
If the BLOB can fit into your memory then setting the LongReadLen attribute
to a large enough value should be sufficient.
If not, ... To be written.
Postgres of course doesn't implement LongReadLen because
of how it handles large objects. According to the DBI
book ('Programming the Perl DBI' by Alligator Descartes
and Tim Bunce, O'Reilly, ISBN 1-56592-699-4), the only
method implemented by DBD::Pg is blob_read(), which is
(DBD::Pg has the following to say about it:
'Supported by this driver as proposed by DBI.
Implemented by DBI but not documented, so this method
Based upon all this, I decided to use DBD::Pg's driver
specific functions (lo_creat, lo_open, lo_import, etc)
until something else is available.
Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
Read Where should I post X? if you're not absolutely sure you're posting in the right place.
Please read these before you post! —
Posts may use any of the Perl Monks Approved HTML tags:
You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
- a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
Link using PerlMonks shortcuts! What shortcuts can I use for linking?
See Writeup Formatting Tips and other pages linked from there for more info.
| & || & |
| < || < |
| > || > |
| [ || [ |
| ] || ] ||