| From: | "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #1046: UNIQUE INDEX BUG |
| Date: | 2004-01-10 10:13:04 |
| Message-ID: | 20040110101304.50860CF4F75@www.postgresql.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1046
Logged by: Alfonso Baqueiro
Email address: abaqueirob(at)hotmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PostgreSQL Bugs List | 2004-01-10 10:23:38 | BUG #1047: sdav |
| Previous Message | Esh, Andrew | 2004-01-09 17:14:14 |