Re: error-free disabling of individual child partition

Tom Lane:

> ALTER TABLE childN DROP INHERITS old_parent;
> ALTER TABLE childN ADD INHERITS new_parent;

I think you would have to make INHERITS a reserved word to make that happen:

stark=> create table integer (i integer);
CREATE TABLE
stark=> alter table test add inherits integer;
ALTER TABLE

-- 
greg