Re: large text fields?

Mike Salib wrote:
>
> Hi,
> I'm trying to find out if I can store more than 8k characters of data in
> one field in a single row. I'm working on a web based app and limiting
> myself to 8k posts is problematic. Has this limitation changed in
> Postgres 7?

No.  You have three options, I think.

(1) Increase the data page size and recompile.

(2) Use the large object interface.

(3) Check out Jan Wieck's TOAST project
(http://www.postgresql.org/projects/devel-toast.html).  It's still in
development, but maybe you can help.

________________________
Ron Peterson
rpeterson@yellowbank.com