psql ERROR : Character Types Tuple is too big: size xxxxx - Mailing list pgsql-interfaces

From Compte utilisateur Sultan-advl
Subject psql ERROR : Character Types Tuple is too big: size xxxxx
Date
Msg-id 00011415015800.01007@sultan
Whole thread Raw
Responses Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx
List pgsql-interfaces
Hi,

From Bruce online book :
"There are synonyms for the terms table, row, and column. Table is more
formally referred to as a relation or class, row as record or tuple, and column
as field or attribute.
" 
====
8Kb limit apply to :
'tuple' when insert ?
'tuple' in design stage (what's append with fixe types) ?
column (Case of fixe types) ???

What's wrong ?
- Design database
- Postgresql limit
Can't find informations on documentation and mail archive's obscure on 8Kb
limit.

Thanks fo help.
Emmanuel DISCORS
http://www.advl.org/kiwi/
===================
Error under psql interface :

A) The tuple in the 'insert' is < 8K but the tuple in table
description is > 8Kb

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 |
+----------------------------------+----------------------------------+-------+
Indices:  localisation_pkey
          localisationi1
          localisationi2
          localisationi3


B) The tuple in the 'insert' is < 8K and the tuple in table
description is < 8Kb

newkiwi=> insert into localisation values ('999', 'ee', 'ff', '999', 'gg', 'hh', 'ii', 'jj', '999');
INSERT 62016 1
newkiwi=> insert into localisation values ('999', 'ee', 'ff', '999', 'gg', 'hh', 'ii', 'jj', '999');
ERROR:  Cannot insert a duplicate key into a unique index
newkiwi=> insert into localisation values ('9998', 'ee', 'ff', '999', 'gg', 'hh', 'ii', 'jj', '999');
INSERT 62018 1
newkiwi=> \d localisation
Table    = localisation
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| id_loc                           | int4 not null                    |     4 |
| voie_loc                         | char()                           |  1024 |
| codebat_loc                      | char()                           |  1024 |
| idplan_loc                       | int4                             |     4 |
| xplan_loc                        | char()                           |  1024 |
| yplan_loc                        | char()                           |  1024 |
| acces_loc                        | char()                           |  1024 |
| accesen_loc                      | char()                           |  1024 |
| id_ville_loc                     | int4                             |     4 |
+----------------------------------+----------------------------------+-------+
Indices:  localisation_pkey
          localisationi1
          localisationi2
          localisationi3
===============================================




pgsql-interfaces by date:

Previous
From: Compte utilisateur Sultan-advl
Date:
Subject: Re: [INTERFACES] tuple too big errors
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx