Postgres Pro
Downloads
Home   >   mailing lists

Re: ignore_system_indexes affects DROP SCHEMA ... CASCADE reported number of objects dropped - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ignore_system_indexes affects DROP SCHEMA ... CASCADE reported number of objects dropped
Date
Msg-id 3849.1525385907@sss.pgh.pa.us
Whole thread Raw
In response to ignore_system_indexes affects DROP SCHEMA ... CASCADE reported numberof objects dropped  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: ignore_system_indexes affects DROP SCHEMA ... CASCADE reportednumber of objects dropped  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Python 3.7 support
Next
From: Mike Palmiotto
Date:
Subject: Proper way to reload config files in backend SIGHUP handler