On Fri, 30 Mar 2001 22:12:16 -0700, Mike Piatek alluded:
<snipped>
> Is there any other way to accomplish this, or am I stuck with having files
> with the text strings and a column indexing the filename?
>
> FYI: I'm using PostgreSQL 7.0.3.
PostgreSQL 7.1 will remove the 32k row limit, allowing strings of
arbitrary
length into columns of type 'text'. 7.1 is now in Release Candidate
2, and
the final release is impending.
The bad news is that there seems to be an issue with DBD::Pg 0.95
and
inserting large amounts of text (it dumps core on my machines). I
would
give 7.1 a go, you might have better luck with the Pg module than I
did
(but let me know in either case while I try to figure it out).
Straight COPYs
of large text work like a charm.
Jeff
--
Jeff Duffy
[EMAIL PROTECTED]
