Re: text field size

On Mon, 26 Feb 2001, [iso-8859-1] Hector Diaz wrote:

> 1) Hi I am a novice in pgsql and I am trying to
> introduce a long text to one record... supposly text
> field size are unlimited but when I tried to insert
> the record the follow message appears :
>
> ERROR: Tuple is too big:size 10000, max size 8140
>
> How I can fix this problem or what do you suggest to
> me?

The nearest I can tell, no SQL dbase has unlimited size
text fields.  You need to rethink what it is you are storing.
Perhaps you are stoing paragraphs, or sentences (for some
definition of a paragraph or sentence: i.e. a sentence in
English will be different than a sentence in the perl programming
language).

Gord

Matter Realisations     http://www.materialisations.com/
Gordon Haverland, B.Sc. M.Eng. President
101  9504 182 St. NW    Edmonton, AB, CA  T5T 3A7
780/481-8019            ghaverla @ freenet.edmonton.ab.ca
780/993-1274 (cell)