| From: | ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca |
|---|---|
| To: | Hector Diaz <hector_diazc(at)yahoo(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: text field size |
| Date: | 2001-02-27 15:46:57 |
| Message-ID: | Pine.A41.3.95.1010227084443.49166B-100000@freenet.edmonton.ab.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Poul L. Christiansen | 2001-02-27 16:36:49 | Re: text field size |
| Previous Message | Oliver Elphick | 2001-02-27 15:33:51 | Re: text field size |