BUG #8677: char(n) - bad limit with arrays of composite type

From: fabio(dot)pasqualini(at)ac-reims(dot)fr
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8677: char(n) - bad limit with arrays of composite type
Date: 2013-12-11 19:01:54
Message-ID: E1Vqp2g-0008Cc-63@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8677
Logged by: Fabio Pasqualini
Email address: fabio(dot)pasqualini(at)ac-reims(dot)fr
PostgreSQL version: 8.4.19
Operating system: Debian
Description:

-- test with psql (8.4.19) on debian

create table t1
(
libelle varchar(100),
cp char(5)
);

create table t2
(
id_t2 integer primary key,
nom varchar(100),
tab_t1 t1 array
);

insert into t2(id_t2, nom, tab_t1)
values ( 1,'test1', '{ "(''toto'', ''1'')", "(''titi'', ''1'')"}' );

insert into t2(id_t2, nom, tab_t1)
values ( 2,'test2', '{ "(''toto'', ''12'')", "(''titi'', ''12'')"}' );

insert into t2(id_t2, nom, tab_t1)
values ( 3,'test3', '{ "(''toto'', ''123'')", "(''titi'', ''123'')"}' );

insert into t2(id_t2, nom, tab_t1)
values ( 4,'test4', '{ "(''toto'', ''1234'')", "(''titi'', ''1234'')"}' );

insert into t2(id_t2, nom, tab_t1)
values ( 5,'test5', '{ "(''toto'', ''12345'')", "(''titi'', ''12345'')"}'
);

CREATE TABLE
psql:./enseignement/bts/2014/prog_c++/carnet2/bug/test.sql:14: NOTICE:
CREATE TABLE / PRIMARY KEY créera un index implicite « t2_pkey » pour la
table « t2 »
CREATE TABLE
INSERT 0 1
INSERT 0 1
psql:./enseignement/bts/2014/prog_c++/carnet2/bug/test.sql:25: ERREUR:
valeur trop longue pour le type character(5)
LIGNE 2 : values ( 3,'test3', '{ "(''toto'', ''123'')", "(''titi'', '...
^
psql:./enseignement/bts/2014/prog_c++/carnet2/bug/test.sql:28: ERREUR:
valeur trop longue pour le type character(5)
LIGNE 2 : values ( 4,'test4', '{ "(''toto'', ''1234'')", "(''titi'', ...
^
psql:./enseignement/bts/2014/prog_c++/carnet2/bug/test.sql:31: ERREUR:
valeur trop longue pour le type character(5)
LIGNE 2 : values ( 5,'test5', '{ "(''toto'', ''12345'')", "(''titi'',...

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message timi 2013-12-12 01:41:18 hi,postgresql bug
Previous Message email 2013-12-11 14:30:04 BUG #8676: Bug Money JSON