public inbox for [email protected]help / color / mirror / Atom feed
wrong information about unlimied size of text field? 4+ messages / 3 participants [nested] [flat]
* wrong information about unlimied size of text field? @ 2002-09-03 12:56 Hubert depesz Lubaczewski <[email protected]> 0 siblings, 2 replies; 4+ messages in thread From: Hubert depesz Lubaczewski @ 2002-09-03 12:56 UTC (permalink / raw) To: pgsql-docs 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: wrong information about unlimied size of text field? @ 2002-09-03 18:53 Bruce Momjian <[email protected]> parent: Hubert depesz Lubaczewski <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Bruce Momjian @ 2002-09-03 18:53 UTC (permalink / raw) To: [email protected]; +Cc: pgsql-docs 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 [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: wrong information about unlimied size of text field? @ 2002-09-03 18:55 Peter Eisentraut <[email protected]> parent: Hubert depesz Lubaczewski <[email protected]> 1 sibling, 1 reply; 4+ messages in thread From: Peter Eisentraut @ 2002-09-03 18:55 UTC (permalink / raw) To: Hubert depesz Lubaczewski <[email protected]>; +Cc: pgsql-docs Hubert depesz Lubaczewski writes: > 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: If you continue reading you will find The storage requirement for data of these types is 4 bytes plus the actual string, and in case of <type>character</type> plus the padding. Long strings will be compressed by the system automatically, so the physical requirement on disk may be less. In any case, the longest possible character string that can be stored is about 1 GB. (The maximum value that will be allowed for <replaceable>n</> in the data type declaration is less than that. It wouldn't be very useful to change this because with multibyte character encodings the number of characters and bytes can be quite different anyway. If you desire to store long strings with no specific upper limit, use <type>text</type> or <type>character varying</type> without a length specifier, rather than making up an arbitrary length limit.) which seems to be the information you are looking for. -- Peter Eisentraut [email protected] ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: wrong information about unlimied size of text field? @ 2002-09-04 16:50 Hubert depesz Lubaczewski <[email protected]> parent: Peter Eisentraut <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Hubert depesz Lubaczewski @ 2002-09-04 16:50 UTC (permalink / raw) To: Peter Eisentraut <[email protected]>; pgsql-docs On Tue, Sep 03, 2002 at 08:55:37PM +0200, Peter Eisentraut wrote: > > 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: > If you continue reading you will find > which seems to be the information you are looking for. o.k. now i know it for sure. but what about others who just stumble on "unlimited length", and just *dont* read further? why put such a false statement in our docs? 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2002-09-04 16:50 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-09-03 12:56 wrong information about unlimied size of text field? Hubert depesz Lubaczewski <[email protected]> 2002-09-03 18:53 ` Bruce Momjian <[email protected]> 2002-09-03 18:55 ` Peter Eisentraut <[email protected]> 2002-09-04 16:50 ` Hubert depesz Lubaczewski <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox