Horton

Re: relhassubclass and partitioned indexes

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Michael Paquier <michael@paquier.xyz>, Tom Lane <tgl@sss.pgh.pa.us>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-10-22T15:45:28Z
Lists: pgsql-hackers 
On 2018-Oct-22, Amit Langote wrote:

> Hi,
> 
> On 2018/10/22 11:09, Michael Paquier wrote:
> > On Fri, Oct 19, 2018 at 06:46:15PM +0900, Amit Langote wrote:
> >> Thanks.  Attached a patch to set relhassubclass when an index partition is
> >> added to a partitioned index.
> > 
> > Thanks, committed after adding a test with ALTER TABLE ONLY, and
> > checking upgrades as well as ATTACH partition for ALTER INDEX and ALTER
> > TABLE.  In all cases the same code paths are taken.
> 
> Thank you for committing with those changes.  I didn't know about create
> index on "only".

pg_dump uses it :-)

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Set pg_class.relhassubclass for partitioned indexes