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

Поиск
Список
Период
Сортировка
От fabio.pasqualini@ac-reims.fr
Тема BUG #8677: char(n) - bad limit with arrays of composite type
Дата
Msg-id E1Vqp2g-0008Cc-63@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #8677: char(n) - bad limit with arrays of composite type  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      8677
Logged by:          Fabio Pasqualini
Email address:      fabio.pasqualini@ac-reims.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'',...

В списке pgsql-bugs по дате отправления:

Предыдущее
От: maxim.boguk@gmail.com
Дата:
Сообщение: BUG #8678: Multiple evaluation single volatile function in select statement
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #8677: char(n) - bad limit with arrays of composite type