Sorry if this is a faq...I'm receiving an error only when inserting
a relatively large amount of data (>55Kb) into a TEXT field on a
postgresql 7.1b4 db. It works fine when I pump the sql statement
into a text file and run, e.g., a "psql < load_me.sql". It also
works if I truncate the file into something ~50Kb.
<code snippet>
my $sizeOfFile=sysread FH, $buf, $len;
my $encodedImage=encode_base64($buf);
close FH;
my $sth=$dbh->prepare("INSERT INTO g_test (image) VALUES (?)");
$sth->execute($encodedImage);
</code snippet>
The error from a trace(4):
<...>
yrqWohgDABOXwgA' (size 52891/708251, otype 1043, indp 0)
dbd_st_execute
Memory fault
Pertinent versions:
DBI 1.14
DBD::Pg 0.93
NetBSD 1.5R
Any suggestions?
Thanks!
--
Michael Santos
[EMAIL PROTECTED]
