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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
