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
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 |