Re: error-free disabling of individual child partition

Ü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