Re: [HACKERS] Broken select on regular expression !!! - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Broken select on regular expression !!!
Date
Msg-id 4292.927256790@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Broken select on regular expression !!!  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: [HACKERS] Broken select on regular expression !!!  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
>> Something is rotten in the state of Denmark...

> These all oddness are caused by the parser (makeIndexable).

Ah-hah, I'm sure you're right.  That makes *two* serious bugs in
makeIndexable.  (We still don't have an adequate solution
for its known problem in non-C locales...)

> It seems that the only solution is checking '|' to see if it appears
> in the target regexp and giving up the optimization in that case.

I'm feeling a strong urge to just rip out makeIndexable until
it can be redesigned... how many other problems has it got
that we haven't stumbled upon?
        regards, tom lane


pgsql-hackers by date:

Previous
From: darcy@druid.net ("D'Arcy" "J.M." Cain)
Date:
Subject: Cache lookup failed
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Broken select on regular expression !!!