question about upper limit on TEXT size

From: Cindy <ctmoore(at)uci(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: question about upper limit on TEXT size
Date: 2002-08-13 00:07:02
Message-ID: 3381.1029197222@stephanus.tlg.uci.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Is this a limit imposed by the C interface? Or something else? I
tried the same INSERT command causing the failure at the psql
commandline interface and got a core dump. If I shorten up the TEXT
field to something on one line or so, the command goes okay (so it's
not something else in the format of that command).

Thoughts, comments? This is very annoying, as I do need to be able to
put in very large amounts of text into that field now and then.

Thanks,
--Cindy
--
ctmoore(at)uci(dot)edu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-08-13 00:31:03 Re: when to use index, and when not to us index - *the* answer :)
Previous Message Peter Darley 2002-08-12 23:50:27 Re: Vacuum problem