| From: | Jaime Casanova <systemguards(at)gmail(dot)com> |
|---|---|
| To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
| Cc: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: is this a bug or I am blind? |
| Date: | 2005-12-15 13:40:14 |
| Message-ID: | c2d9e70e0512150540s52dedbbp84231f96acd60e83@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/15/05, Csaba Nagy <nagy(at)ecircle-ag(dot)com> wrote:
> [snip]
> > even is that is true i think you need the "comodin characters" (ie: %.
> > _) to make "like" behave different from simple comparisons
>
> Not entirely true, if the database was initialized in a different locale
> than C, then the direct comparison will probably go for an index on
> username, while "like" will not. Which points to a possible index
> corruption... which might be interesting for the developers to
> investigate, but I would guess a reindex will solve the problem for the
> OP if he has it urgent...
>
> Cheers,
> Csaba.
>
>
Mage if it's not urgent maybe you can make a post in -hackers and
follow instructions about how to get more info to see what happened
here...
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2005-12-15 13:42:43 | Re: is this a bug or I am blind? |
| Previous Message | Richard Huxton | 2005-12-15 13:35:07 | Re: is this a bug or I am blind? |