Re: 8.0.5 Bug in unique indexes?

Michael Paesold wrote:
> Joshua D. Drake wrote:
> 
>> Tom Lane wrote:
>>> What's the database's locale?  This could be the same problem fixed in
>>> 8.0.6, if the locale has weird ideas about what string equality means.
> 
>> lc_collate                     | C
>> lc_ctype                       | C
> 
> You don't user pl/perl, do you -- i.e. I guess you read the latest 
> release notes and the thread here before that?

Yes I did. I didn't know that the person was running plPerl. I have 
verified that they are. We are now going to check if upgrading to 8.0.6
with a deletion of the duplicates and a reindex resolves the issue.

Sincerely,

Joshua D. Drake


> 
> Best Regards,
> Michael
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly


-- 
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/