Horton

Re: missing indexes in indexlist with partitioned tables

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
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>
Date: 2022-10-02T23:07:24Z
Lists: pgsql-hackers 
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

Commits

  1. Allow left join removals and unique joins on partitioned tables

  2. Add index on pg_publication_rel.prpubid