Re: orderRules() now a bad idea?

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: orderRules() now a bad idea?
Дата
Msg-id 3DAC1932.7E6477A@Yahoo.com
обсуждение исходный текст
Ответ на orderRules() now a bad idea?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> 
> I just noticed that rewriteHandler.c contains a subroutine orderRules()
> that reorders the rules for a relation into the order
>         non-instead rules
>         qualified instead rules
>         unqualified instead rules
> This conflicts with the feature we'd added to 7.3 to fire rules in
> alphabetical order.  (What will presently happen is they'll be fired
> alphabetically in each of these categories.)
> 
> I see that the logic in fireRules() assumes that rules are processed in
> this order, but that would be fairly easy to fix.  Is there any other
> good reason for doing this reordering?  I'd like to remove orderRules()
> and implement straight alphabetical ordering.

I don't see a strong reason why not doing it the way you propose. It's
just that you need to keep a version of the parsetree before you applied
an unqualified instead rule just for the case that you later need to
apply one of the others. But this copy shall not make it into the final
list of queries.


Jan

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: droped out precise time calculations in src/interfaces/libpq/fe-connect.c
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: oid2name and relfilenode