From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Arne Roland <A.Roland@index.de>
Cc: Amit Langote <amitlangote09@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Cc: Zhihong Yu <zyu@yugabyte.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Julien Rouhaud <rjuju123@gmail.com>
Subject: Re: missing indexes in indexlist with partitioned tables
Date: Sun, 02 Oct 2022 19:07:24 -0400
Message-ID: <1311202.1664752044@sss.pgh.pa.us> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, dgrowleyml@gmail.com, A.Roland@index.de, amitlangote09@gmail.com, zyu@yugabyte.com, alvherre@alvh.no-ip.org, rjuju123@gmail.com
Subject: Re: missing indexes in indexlist with partitioned tables
In-Reply-To: <1311202.1664752044@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox