Re: question about upper limit on TEXT size

Cindy <ctmoore@uci.edu> writes:
> Hi, all.  I'm working with a database record that includes one field
> of type text.  It's my understanding there is no upper limit on this
> data type's size.  However, I'm running into size related problems
> with this.  It could be due to the interface I'm using (my programs
> are in C, and I'm using the libpq-fe.h interface (version 1.80 of
> 2001/11/08).  On the PGresult var I'm getting back, the
> PQresultErrorMessage is telling me ERROR: Tuple is too big: size
> 54776, max size 8128

<blink> What Postgres version are you using?  If it's recent (7.1
or later), could we see the full schema of your table?

            regards, tom lane