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

From Zeugswetter Andreas DCP SD
Subject Re: error-free disabling of individual child partition
Date
Msg-id E1539E0ED7043848906A8FF995BDA57901054A9F@m0143.s-mxs.net
Whole thread Raw
Responses Re: error-free disabling of individual child partition  (Simon Riggs <simon@2ndquadrant.com>)
Re: error-free disabling of individual child partition  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > 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.

>
> 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 :-)

Andreas


pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Re: Porting MSSQL to PGSQL (Was: [OT] MySQL is bad, but THIS bad?)
Next
From: Simon Riggs
Date:
Subject: Re: error-free disabling of individual child partition