Lists: | pgsql-interfaces |
---|
From: | Compte utilisateur Sultan-advl <webmaster(at)advl(dot)org> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Fwd: Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx |
Date: | 2000-01-14 18:30:00 |
Message-ID: | 00011419312100.02025@sultan |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | 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(at)advl(dot)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
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | webmaster(at)advl(dot)org |
Cc: | pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | Re: Fwd: Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx |
Date: | 2000-01-14 21:28:54 |
Message-ID: | 1162.947885334@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-interfaces |
Compte utilisateur Sultan-advl <webmaster(at)advl(dot)org> writes:
> [ tuple definition is bigger than 8K ]
> BUT why psql does not raise an error in 'create table' ?
> Maybe documentation needs more informations on this ? (In Data types)
Well, actually, we are more interested in getting rid of the limitation
than in adding more code that depends on it... there may even be a fix
in 7.0...
regards, tom lane
From: | Joseph Shraibman <jks(at)p1(dot)selectacast(dot)net> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: Fwd: Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx |
Date: | 2000-01-27 03:21:57 |
Message-ID: | 388FB9D5.2B97A155@selectacast.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-interfaces |
Tom Lane wrote:
> Compte utilisateur Sultan-advl <webmaster(at)advl(dot)org> writes:
> > [ tuple definition is bigger than 8K ]
> > BUT why psql does not raise an error in 'create table' ?
> > Maybe documentation needs more informations on this ? (In Data types)
>
> Well, actually, we are more interested in getting rid of the limitation
> than in adding more code that depends on it... there may even be a fix
> in 7.0...
>
> regards, tom lane
>
> ************
I found this in the hackers mailing list archive:
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> at Technische
Universitaet Muenchen, Germany
Can I ask how our big open items for 7.0 are doing:
Long tuples/TOAST(Jan)
Foriegn keys/action buffer(Jan)
Unify date/time types(Thomas)
Outer Joins(Thomas)
I am only asking to know if we should continue with the planned Feb 1
beta?
====================END CLIP.
The problem is that none of the followups mentioned long tuples, so that
might have slipped through the cracks.