From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200209031853.g83Ir6H10200@candle.pha.pa.us>
Subject: Re: wrong information about unlimied size of text field?
In-Reply-To: <20020903125655.GA24879@depesz.pl>
To: depesz@depesz.pl
Date: Tue, 3 Sep 2002 14:53:05 -0400 (EDT)
Cc: pgsql-docs@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII


Current FAQ on web site lists limit as 1GB.  I think I fixed that only recently.

---------------------------------------------------------------------------

Hubert depesz Lubaczewski wrote:
-- Start of PGP signed section.
> hi
> according to what i know, where is a limit for up to 2gigabytes of data
> in text fields (according to c.h).
> this limit is of course very big, but i belive it should be mentioned in
> datatype.sgml instead of saying:
> 
> <entry><type>text</type></entry>
> <entry>Variable unlimited length</entry>
> 
> if this is not the case, i'd like some information how longer text's can
> be stored, when text is internally of "varlena" type, where
> varlena.vl_len is of int32 type.
> 
> best regards
> 
> depesz
> 
> -- 
> hubert depesz lubaczewski                          http://www.depesz.pl/
> ------------------------------------------------------------------------
> M?j Bo?e, spraw abym milcza?, dop?ki si? nie upewni?,  ?e  naprawd?  mam
> co? do powiedzenia.                                      (c) 1998 depesz
> 
-- End of PGP section, PGP failed!

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073