From: | Compte utilisateur Sultan-advl <webmaster(at)advl(dot)org> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org, pgman(at)candle(dot)pha(dot)pa(dot)us, pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Cc: | jks(at)p1(dot)selectacast(dot)net, chalaoux(at)cybercable(dot)fr |
Subject: | psql ERROR : Character Types Tuple is too big: size xxxxx |
Date: | 2000-01-14 13:29:34 |
Message-ID: | 00011415015800.01007@sultan |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general 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
===============================================
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-01-14 15:34:14 | Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx |
Previous Message | Hojdar Karel Ing. | 2000-01-14 13:22:48 | How to get number of the week from datetime? |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-01-14 15:34:14 | Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx |
Previous Message | Compte utilisateur Sultan-advl | 2000-01-14 12:13:35 | Re: [INTERFACES] tuple too big errors |