Re: Tuple is to big - Mailing list pgsql-general

From Dan McGrath
Subject Re: Tuple is to big
Date
Msg-id 3A897C0C.9E2EBBC2@home.com
Whole thread Raw
List pgsql-general
Actually, you should take a look in the documentation. It specifically
states that the maximum size for any tuple is 8k (unless compiled
otherwise). If you want to store something larger, consider using the large
objects feature.

Dan

Bodoni Endre wrote:

> I have a little trouble with my PostgreSQL 6.5.1. I use a table with
> text character type.
> When I try to insert about 10000 character long string into it I've got
> an error message like:
> ERROR:  Tuple is too big: size 10172
> Is there any limitation for a variable length text type?
> If any, how long is it?
>
> Regards,
> Endre Bodoni


pgsql-general by date:

Previous
From: "Mourad EL HADJ MIMOUNE"
Date:
Subject: List set bag support
Next
From: Raymond Chui
Date:
Subject: Re: How to make PostgreSQL JDBC drive get PGTZ?