In pre 7.0 versions there was an 8k query size limit and in all pre 7.1
versions a limit on the size of a field (BLCKSZ from 8k (default) to 32k)...
I'd say it's either in there to prevent one or the other.
Of course 8140 isn't quite 8k but *shrug*..
-Mitch
----- Original Message -----
From: "John Madden" <weez@freelists.org>
To: <pgsql-general@postgresql.org>
Sent: Saturday, February 17, 2001 12:51 PM
Subject: DBD::Pg problem?
> The DBD::Pg perl module for some reason has a limit of 8140 bytes when
> inserting, and I don't see why (yeah, I'll be contacting the authors there
> too), but I thought I'd ask here... I'm writing a Postgres-backed mail
> client, and storing emails in the database is obviously a little difficult
> when you can't insert more than 8k.
>
> Does anyone know why this limit exists, or if there's a way around it?
>
> John
>
>
>
>
>
> --
> # John Madden weez@freelists.org ICQ: 2EB9EA
> # FreeLists, Free mailing lists for all: http://www.freelists.org
> # UNIX Systems Engineer, Ivy Tech State College: http://www.ivy.tec.in.us
> # Linux, Apache, Perl and C: All the best things in life are free!
>
