Fwd: Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx
От | Compte utilisateur Sultan-advl |
---|---|
Тема | Fwd: Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx |
Дата | |
Msg-id | 00011419312100.02025@sultan обсуждение исходный текст |
Ответы |
Re: Fwd: Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx
|
Список | pgsql-interfaces |
Thanks Tom, Taking the choice of 'text' fields ; "no needs of blank-padding in every record..." BUT why psql does not raise an error in 'create table' ? Maybe documentation needs more informations on this ? (In Data types) Emmanuel. Le ven, 14 jan 2000, vous avez �crit : > 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
В списке pgsql-interfaces по дате отправления: