From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
cc: Arne Roland <A.Roland@index.de>, Amit Langote <amitlangote09@gmail.com>,
        pgsql-hackers <pgsql-hackers@postgresql.org>,
        Zhihong Yu <zyu@yugabyte.com>,
        Alvaro Herrera <alvherre@alvh.no-ip.org>,
        Julien Rouhaud <rjuju123@gmail.com>
Subject: Re: missing indexes in indexlist with partitioned tables
In-reply-to: 
 <CAApHDvpJVmf27UX2MyXC3h4WYbFah_PfhWxM7QHLCtFG90TB9A@mail.gmail.com>
References: <20220118065750.v5zigpuisljc6jmk@jrouhaud>
 <202201181324.idvthmrhbtf5@alvherre.pgsql>
 <CA+HiwqFtJTNg7cvwhShMStEm-F8L8q2pEhxp1SZA-oaCxQHZ=g@mail.gmail.com>
 <24e924b48a8a47649d6a92cb1c95eb4b@index.de>
 <CAApHDvpJVmf27UX2MyXC3h4WYbFah_PfhWxM7QHLCtFG90TB9A@mail.gmail.com>
Comments: In-reply-to David Rowley <dgrowleyml@gmail.com>
	message dated "Mon, 03 Oct 2022 11:51:45 +1300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1311201.1664752044.1@sss.pgh.pa.us>
Date: Sun, 02 Oct 2022 19:07:24 -0400
Message-ID: <1311202.1664752044@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1311202.1664752044%40sss.pgh.pa.us>
Precedence: bulk

David Rowley <dgrowleyml@gmail.com> writes:
> * I can't quite figure out why you're doing "DROP TABLE a CASCADE;" in
> inherits.sql.  You've not changed anything else in that file. Did you
> mean to do this in join.sql?

Doing that would be a bad idea no matter where it's done.  IIRC,
those tables are intentionally set up to stress later dump/restore
tests (with issues like inheritance children having column order
different from their parents).

			regards, tom lane