BUG #1046: UNIQUE INDEX BUG - Mailing list pgsql-bugs

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