Re: error-free disabling of individual child partition - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: error-free disabling of individual child partition
Date
Msg-id 1148383855.3798.3.camel@localhost.localdomain
Whole thread Raw
In response to Re: error-free disabling of individual child partition  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Ühel kenal päeval, T, 2006-05-23 kell 10:51, kirjutas Simon Riggs:
> On Tue, 2006-05-23 at 09:49 +0200, Zeugswetter Andreas DCP SD wrote:
> > > > table of another table. I propose a TODO item to allow this:
> > > >
> > > >     ALTER TABLE childN INHERITS ( parent1, ... );
> > 
> > > > We don't need a disinherit do we?
> > 
> > I propose: ALTER TABLE childN INHERITS ();
> > Thus I also think, that the list should be complete, and is not an
> > addition 
> > to existing inheritance.
> 
> Sounds good; an absolute rather than a relative approach. Avoids new
> keywords.

And also allows you move a partition from live to archive table in one
command. Brilliant :)

> Implementation is simpler too:
> - check that we have all required merged attributes (if any)
> - remove any inheritance that isn't on the list
> 
> If the table is already INHERITS (x) and we specify INHERITS (x) then
> its a no-op that returns success.
>  
> > > O, yes, I think we do. I can imagine that the ability to swap a table 
> > 
> > Agreed. Simon, were you testing how many ppl read to the end :-)
> 
> Just seeing who cared. DROP TABLE removes inheritance too, in a Keyser
> Soze manner.

Just fyi - I care too .

-- 
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com





pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: error-free disabling of individual child partition
Next
From: Dhanaraj M
Date:
Subject: Performance Issues