Thread

1. Re: Tuple is to big

   Dan McGrath <dmcgrath19@home.com> — 2001-02-13T18:25:16Z

   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
   
   
   

2. Tuple is to big

   Bodoni Endre <endre@netsoft.ro> — 2001-02-13T21:11:59Z

   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
   
   
   

3. Re: Tuple is to big

   Anand Raman <araman@india-today.com> — 2001-02-15T05:41:24Z

   hi Endre
   U can go upto 32 k on 7.0.x and there is no such limit on 7.1
   Try to upgrade..
   Regards
   Anand
   On Tue, Feb 13, 2001 at 04:11:59PM -0500, 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