large text fields

From: "Kevin Heflin" <kheflin(at)shreve(dot)net>
To: "psql" <pgsql-general(at)postgreSQL(dot)org>
Subject: large text fields
Date: 2000-04-06 19:48:24
Message-ID: 009101bfa001$11f0abe0$144cced0@shreve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

when ever I've dealt with a field that would require more text than 250
characters, I've always used the 'text' datatype. It appears I've hit an
example where this won't work. users are trying to insert what amounts to
about 2 pages worth of text and I'm seeing this error:

PostgresSQL query failed: ERROR: Tuple is too big: size 10000

Are there any other options other than using a BLOB datatype ? which I'm
completely unfamiliar with.

Kevin

----------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Production | 333 Texas St #619 | FAX:318.221.6612
kheflin(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
-----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2000-04-06 20:22:47 Re: large text fields
Previous Message Nilesh A. Phadke 2000-04-06 16:59:45 Fetching from cursor....