Re: [HACKERS] Broken select on regular expression !!!

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Broken select on regular expression !!!
Дата
Msg-id 4292.927256790@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Broken select on regular expression !!!  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Ответы Re: [HACKERS] Broken select on regular expression !!!  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: darcy@druid.net ("D'Arcy" "J.M." Cain)
Дата:
Сообщение: Cache lookup failed
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Broken select on regular expression !!!