Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx
От | Compte utilisateur Sultan-advl |
---|---|
Тема | Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx |
Дата | |
Msg-id | 00011419044100.01934@sultan обсуждение исходный текст |
Ответ на | Re: [NOVICE] Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx ("D. Duccini" <duccini@backpack.com>) |
Список | pgsql-interfaces |
Hi, Just to see if psql raise an error message ;-) Emmanuel. Le ven, 14 jan 2000, D. Duccini a �crit : > and on top of that, why insert character strings into columns expecting > numeric values? > > defintely use VARCHAR unless you are going to be filling those columns up > > -duck > > > Compte utilisateur Sultan-advl <webmaster@advl.org> writes: > > > newkiwi=> insert into localisation values ('999', 'ee', 'ff', '999', 'gg', > > > 'hh', 'ii', 'jj', '999'); > > > ERROR: Tuple is too big: size 12356 > > > newkiwi=> \d localisation > > > Table = localisation > > > +----------------------------------+----------------------------------+-------+ > > > | Field | Type | Length| > > > +----------------------------------+----------------------------------+-------+ > > > | id_loc | int4 not null | 4 | > > > | voie_loc | char() | 2048 | > > > | codebat_loc | char() | 2048 | > > > | idplan_loc | int4 | 4 | > > > | xplan_loc | char() | 2048 | > > > | yplan_loc | char() | 2048 | > > > | acces_loc | char() | 2048 | > > > | accesen_loc | char() | 2048 | > > > | id_ville_loc | int4 | 4 | > > > +----------------------------------+----------------------------------+-------+ > > > > Well, you've got six fixed-size 2K fields, which are going to take up > > 12K all by themselves, plus there's a few dozen bytes of overhead. > > > > I'd suggest using varchar or text instead of char --- do you really > > need 12K of blank-padding in every record? > > > > regards, tom lane > > > > ************ > > > > > ----------------------------------------------------------------------------- > david@backpack.com BackPack Software, Inc. www.backpack.com > +1 651.645.7550 voice "Life is an Adventure. > +1 651.645.9798 fax Don't forget your BackPack!" > -----------------------------------------------------------------------------
В списке pgsql-interfaces по дате отправления: