Re: DBD::Pg problem? - Mailing list pgsql-general

From Mitch Vincent
Subject Re: DBD::Pg problem?
Date
Msg-id 002501c0990b$3e70e550$0200000a@windows
Whole thread Raw
In response to DBD::Pg problem?  (John Madden <weez@freelists.org>)
List pgsql-general
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!
>


pgsql-general by date:

Previous
From: John Madden
Date:
Subject: DBD::Pg problem?
Next
From: Peter Eisentraut
Date:
Subject: Re: Function reference