| From: | Dan McGrath <dmcgrath19(at)home(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tuple is to big |
| Date: | 2001-02-13 18:25:16 |
| Message-ID: | 3A897C0C.9E2EBBC2@home.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | J.H.M. Dassen Ray | 2001-02-13 18:31:20 | Re: Postmaster crashes |
| Previous Message | Peter Eisentraut | 2001-02-13 18:24:59 | Re: How create SQL variable sentense in plpgsql?! |