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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ignore_system_indexes affects DROP SCHEMA ... CASCADE reported number of objects dropped
Date: 2018-05-03 22:18:27
Message-ID: 3849.1525385907@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Geoghegan <pg(at)bowt(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Malcontent null 2018-05-03 22:22:27 Re: Why Not MySQL?
Previous Message Tom Lane 2018-05-03 22:10:40 Re: Python 3.7 support