From: | "Holt, Jack C(dot)" <JACK(dot)C(dot)HOLT(at)saic(dot)com> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: TEXT field's length limit in PostgreSQL |
Date: | 2001-10-18 17:05:03 |
Message-ID: | 5699C9C65589D111917B00805FBBE4D801865F5A@US-CPE.mail.saic.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Take a look at www.postgresql.org/docs/index.php?datatype-character.html. Be
sure to take a look at the comments at the bottom of the page. The
documentation agrees with you, but Peter Eisentraut gives a different take.
-----Original Message-----
From: Brett W. McCoy [mailto:bmccoy(at)chapelperilous(dot)net]
Sent: Thursday, October 18, 2001 6:50 AM
To: Michal 'Samuel' Modestowicz
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] TEXT field's length limit in PostgreSQL
On Thu, 18 Oct 2001, [iso-8859-2] Micha³ 'Samuel' Modestowicz wrote:
> I know that my question may seem trivial, but unfortunately I haven't
found
> any understandable info on this topic. It's about length limit of the TEXT
> field in PostgreSQL. I've heard that the TEXT fields in psql are limited
to
> 4096 bytes but it's just unbelievable for me. So if I've got text of more
> than 4096 bytes size, for example article - do I really have to put it in
> the LOB field and use these terrific lo-functions to access it ?? Please,
if
> anyone can help me - write to samuel(at)netmagia(dot)pl .
The limitation is gone in 7.1. According to the documentation, the length
is unlimited. Realistically, I think sizes of around 1G are the discrete
limit.
-- Brett
http://www.chapelperilous.net/
------------------------------------------------------------------------
Even moderation ought not to be practiced to excess.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
From | Date | Subject | |
---|---|---|---|
Next Message | Keary Suska | 2001-10-18 17:43:43 | Re: Accessing PostgreSQL through Apache and PHP4 on |
Previous Message | Bruce Momjian | 2001-10-18 16:27:33 | Re: Break both? (Was To Postgres Devs : Wouldn't changing |