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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ignore_system_indexes affects DROP SCHEMA ... CASCADE reported number of objects dropped
Дата
Msg-id 3849.1525385907@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ignore_system_indexes affects DROP SCHEMA ... CASCADE reported numberof objects dropped  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: ignore_system_indexes affects DROP SCHEMA ... CASCADE reportednumber of objects dropped  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
Peter Geoghegan <pg@bowt.ie> writes:
> Why should the drop cascade to 63 objects rather than 62 because I've
> set ignore_system_indexes=on?

Indeed, that seems weird.  Maybe tweak the test scripts so you can see
all the objects cascaded to, and then find out what the additional
object is?  (I think also you could look into the postmaster log,
without changing the test.)

            regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Python 3.7 support
Следующее
От: Mike Palmiotto
Дата:
Сообщение: Proper way to reload config files in backend SIGHUP handler