Collation problem

[Andrei Gaspar <andi@xxxxxxxxxxxxxxxx>]

Hi all,
I have a table TranslationDictionary in a database initalized with 
lc_collation and lc_type de-de .
In the table is the value 'Straße' and I can't insert 'Strasse', but 
when I try to create a foreign key on this table, the value 'Strasse' in 
the foreign table is unmatched.
Is this a bug, or have I done something wrong?

\d TranslationDictionary
  Table "translationdictionary"
    Column     |      Type      | Modifiers
----------------+----------------+-----------
ckeydictionary | character(250) | not null
cvalue         | character(250) |
Indexes:
   "translationdictionary_pkey" PRIMARY KEY, btree (ckeydictionary)


insert into tkp.TranslationDictionary (cKeyDictionary, cValue) values 
('Strasse', 'Strasse');
ERROR:  duplicate key violates unique constraint 
"translationdictionary_pkey"


select * from tkp.TranslationDictionary where cKeyDictionary = 'Strasse';
ckeydictionary | cvalue
----------------+--------
(0 rows)


Andrei



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 5/10/2005


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx