Horton

Re: relhassubclass and partitioned indexes

Amit Langote <langote_amit_f8@lab.ntt.co.jp>

View thread View on postgr.es
From: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Michael Paquier <michael@paquier.xyz>, Tom Lane <tgl@sss.pgh.pa.us>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-10-23T00:28:53Z
Lists: pgsql-hackers 
On 2018/10/23 0:45, Alvaro Herrera wrote:
> 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 :-)

Aha, I see.

Thanks,
Amit

Commits

  1. Set pg_class.relhassubclass for partitioned indexes