Re: ignore_system_indexes affects DROP SCHEMA ... CASCADE reported number of objects dropped

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: ignore_system_indexes affects DROP SCHEMA ... CASCADE reported number of objects dropped
Дата
Msg-id 874ljo81ck.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: ignore_system_indexes affects DROP SCHEMA ... CASCADE reportednumber of objects dropped  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
>>>>> "Peter" == Peter Geoghegan <pg@bowt.ie> writes:

 Peter> There are a couple of other odd things that look related, such
 Peter> as this extract from the triggers.out section of my
 Peter> regression.diffs:

That one is pretty obvious (from RelationBuildTriggers):

     * Note: since we scan the triggers using TriggerRelidNameIndexId, we will
     * be reading the triggers in name order, except possibly during
     * emergency-recovery operations (ie, IgnoreSystemIndexes). This in turn
     * ensures that triggers will be fired in name order.

Nothing in the code attempts to preserve the order of trigger firing in
the ignore_system_indexes=on case.

-- 
Andrew (irc:RhodiumToad)


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

Предыдущее
От: Mike Palmiotto
Дата:
Сообщение: Re: Proper way to reload config files in backend SIGHUP handler
Следующее
От: Aleksandr Parfenov
Дата:
Сообщение: Optimze usage of immutable functions as relation