Re: 8.0.5 Bug in unique indexes?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Michael Paesold <mpaesold(at)gmx(dot)at>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: 8.0.5 Bug in unique indexes?
Date: 2006-01-19 18:23:16
Message-ID: 43CFD914.40303@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)postgresql(dot)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/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Scott 2006-01-19 18:29:01 Re: No heap lookups on index
Previous Message Josh Berkus 2006-01-19 18:19:01 Re: No heap lookups on index