Re: [HACKERS] Proposal: Local indexes for partitioned table - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Proposal: Local indexes for partitioned table
Date
Msg-id f6f2790d-4c30-349a-ab37-c11730169b9a@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] Proposal: Local indexes for partitioned table  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: [HACKERS] Proposal: Local indexes for partitioned table
List pgsql-hackers
On 12/29/17 15:38, Alvaro Herrera wrote:
> I just realized there's a further problem in the area: when a partition
> is detached from its parent, its indexes are not made independent of the
> indexes on parent.  So they can't be dropped on their own (booh!); and
> dropping the index on the former parent partitioned table drops the
> index on the former partition also (hiss!).  I think the fix for this is
> to delete all dependencies, and re-register normal ones.  Should be
> straightforward, but I'm not doing it this year.

We're waiting for an updated patch in this thread, aren't we?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: legrand legrand
Date:
Subject: Re: AS OF queries
Next
From: Andres Freund
Date:
Subject: Re: [Patch] Make block and file size for WAL and relations definedat cluster creation