BUG #1046: UNIQUE INDEX BUG

Поиск
Список
Период
Сортировка
Искать
От
PostgreSQL Bugs List
Тема
BUG #1046: UNIQUE INDEX BUG
Дата
Msg-id
20040110101304.50860CF4F75@www.postgresql.com
Список
Дерево обсуждения
BUG #1046: UNIQUE INDEX BUG "PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>
Re: BUG #1046: UNIQUE INDEX BUG Tom Lane <tgl@sss.pgh.pa.us>
The following bug has been logged online:

Bug reference:      1046
Logged by:          Alfonso Baqueiro

Email address:      abaqueirob@hotmail.com

PostgreSQL version: 7.3.2

Operating system:   Linux Redhat 9.0

Description:        UNIQUE INDEX BUG

Details: 

create table pru(
  id integer not null primary key,
  login varchar(10) unique not null
);

then when inserting values it says á = é = í = ó = ú
(confuses different acuted vowels as if they were the same thing)

insert into pru (0, 'á');
-- no problem

But the error shows when trying the next:
insert into pru (1, 'é');
-- ERROR: cannot insert a duplicate key into unique index ...

Is a horrible bug that stops my migration from Centura SQLBase to PostgreSQL
В списке pgsql-bugs по дате отправления
От: Esh, Andrew
Дата:
Сообщение:
От: PostgreSQL Bugs List
Дата:
Сообщение: BUG #1047: sdav
FAQ