ignore_system_indexes affects DROP SCHEMA ... CASCADE reported numberof objects dropped
От | Peter Geoghegan |
---|---|
Тема | ignore_system_indexes affects DROP SCHEMA ... CASCADE reported numberof objects dropped |
Дата | |
Msg-id | CAH2-Wz=wAKwhv0PqEBFuK2_s8E60kZRMzDdyLi=-MvcM_pHN_w@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: ignore_system_indexes affects DROP SCHEMA ... CASCADE reported number of objects dropped
|
Список | pgsql-hackers |
Setting ignore_system_indexes=off in postgresql.conf has the effect of making almost all regression tests fail during a "make installcheck". This is unsurprising, since warnings are emitted all over the place. However, some of the specific ways in which it fails *are* surprising. I see the following regressions.diff, for the create_view tests: *************** *** 1711,1714 **** DROP SCHEMA temp_view_test CASCADE; NOTICE: drop cascades to 27 other objects DROP SCHEMA testviewschm2 CASCADE; ! NOTICE: drop cascades to 62 other objects --- 1725,1732 ---- DROP SCHEMA temp_view_test CASCADE; NOTICE: drop cascades to 27 other objects DROP SCHEMA testviewschm2 CASCADE; ! NOTICE: drop cascades to 63 other objects ! WARNING: using index "pg_toast_2618_index" despite IgnoreSystemIndexes ! WARNING: using index "pg_toast_2618_index" despite IgnoreSystemIndexes ! WARNING: using index "pg_toast_2618_index" despite IgnoreSystemIndexes ! WARNING: using index "pg_toast_2618_index" despite IgnoreSystemIndexes Why should the drop cascade to 63 objects rather than 62 because I've set ignore_system_indexes=on? I know that the order of objects is unspecified/unstable for the verbose DETAIL output of CASCADE, but that's rather a different thing to the total number of objects affected. The same thing happens to the collate tests: *************** *** 668,671 **** -- \set VERBOSITY terse DROP SCHEMA collate_tests CASCADE; ! NOTICE: drop cascades to 17 other objects --- 676,679 ---- -- \set VERBOSITY terse DROP SCHEMA collate_tests CASCADE; ! NOTICE: drop cascades to 20 other objects -- Peter Geoghegan
В списке pgsql-hackers по дате отправления: