pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: webmaster@advl.org
Cc: pgsql-interfaces@postgreSQL.org
Cc: pgsql-novice@postgreSQL.org
Cc: pgsql-general@postgreSQL.org
Subject: Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx
Date: Fri, 14 Jan 2000 10:34:14 -0500
Message-ID: <29531.947864054@sss.pgh.pa.us> (raw)
In-Reply-To: <00011415015800.01007@sultan>
References: <00011415015800.01007@sultan>

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

view thread (7+ messages)  latest in thread

Message-ID: <29531.947864054@sss.pgh.pa.us>
Permalink:  ../29531.947864054@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/29531.947864054@sss.pgh.pa.us

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: tgl@sss.pgh.pa.us, webmaster@advl.org, pgsql-novice@postgreSQL.org, pgsql-general@postgreSQL.org
  Subject: Re: [INTERFACES] psql ERROR : Character Types Tuple is too big: size xxxxx
  In-Reply-To: <29531.947864054@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox