Collation problem

From: Andrei Gaspar <andi(at)softnrg(dot)dnttm(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: Collation problem
Date: 2005-05-12 05:37:04
Message-ID: 4282EB80.9000101@softnrg.dnttm.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Patrick.FICHE 2005-05-12 08:01:34 pgadmin on Solaris
Previous Message Jerome Macaranas 2005-05-12 05:33:55 Re: Need input on postgres used for phpBB