Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 54757475EFD for ; Tue, 3 Sep 2002 12:04:37 -0400 (EDT) Received: from spike.esolution.pl (unknown [217.11.134.154]) by postgresql.org (Postfix) with ESMTP id 665D1475EA4 for ; Tue, 3 Sep 2002 12:04:36 -0400 (EDT) Received: from pb137.warszawa.cvx.ppp.tpnet.pl ([213.76.97.137] helo=depesz.pl) by spike.esolution.pl with esmtp (Exim 4.10) id 17mG62-00009a-00 for pgsql-docs@postgresql.org; Tue, 03 Sep 2002 18:00:13 +0200 Received: from depesz by depesz.pl with local (Exim 3.36 #1) id 17mDEm-00079r-00 for pgsql-docs@postgresql.org; Tue, 03 Sep 2002 14:56:56 +0200 Date: Tue, 3 Sep 2002 14:56:55 +0200 From: Hubert depesz Lubaczewski To: pgsql-docs@postgresql.org Subject: wrong information about unlimied size of text field? Message-ID: <20020903125655.GA24879@depesz.pl> Reply-To: depesz@depesz.pl Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="Nq2Wo0NMKNjxTN9z" Content-Disposition: inline User-Agent: Mutt/1.4i X-info-en-1: this message *may* reflect my personal opinion. it is *not* X-info-en-2: intended to reflect those of my employer, or anyone else. X-info-pl-1: wszelkie opinie =?iso-8859-2?Q?wyra=BFone_?= =?iso-8859-2?Q?w_tym_li=B6cie_prezentuj=B1_wy=B3=B1cznie_pogl=B1dy?= X-info-pl-2: autora listu. opinie =?iso-8859-2?Q?te_?= =?iso-8859-2?Q?w_=BFadnym__razie_nie__wyra=BFaj=B1__pogl=B1d=F3w?= X-info-pl-3: pracodawcy autora =?iso-8859-2?Q?listu_?= =?iso-8859-2?Q?_ani__innych__zwi=B1zanych__z__nim__os=F3b=2E?= X-Operating-System: Linux 2.2.21 i686 AMD_Athlon(tm)_Processor X-code: perl -e 's&&_b`s .oqnb.lntmsr_&&&y&, -{&--|&&&s&&$_&ee&&map{y&--|&, -{&&&s&&_gd`c , b14///// .cdu.tq`mcnl=${_}_&&&y&, -{&--|&&&s ee$_eee}grep m m[hs]dwm&&!$x{$_}++, map m msm&&$`, split v10' X-Scanner: exiscan for exim4 (http://duncanthrax.net/exiscan/) *17mG62-00009a-00*5cMQRkiufKQ* X-Spam-Score: -3.2 (---) X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/13 X-Sequence-Number: 1465 --Nq2Wo0NMKNjxTN9z Content-Type: text/plain; charset=iso-8859-2 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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: text Variable unlimited length 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 --=20 hubert depesz lubaczewski http://www.depesz.pl/ ------------------------------------------------------------------------ M=F3j Bo=BFe, spraw abym milcza=B3, dop=F3ki si=EA nie upewni=EA, =BFe na= prawd=EA mam co=B6 do powiedzenia. (c) 1998 depesz --Nq2Wo0NMKNjxTN9z Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9dLGXKBwKA0prOAkRAkuCAKCp/DgfdnH9shjakwXsSLVSg9ln6ACfUCcg kA0b28jFhhrv5nSumeegopU= =SgYs -----END PGP SIGNATURE----- --Nq2Wo0NMKNjxTN9z--