Simon Riggs wrote:
Based on the test case Tom shows, I think we need to enforce that ADD
INHERITS will barf if the columns are not in exactly the order they
would have been in if we add done a CREATE ... INHERITS followed by a
DROP INHERITS. That wouldn't be a problem if we just say to people, if
you want to create a new partition do:
CREATE TABLE new_child ... LIKE child;
then later
ALTER TABLE new_partition ADD INHERITS parent;
This seems like a very reasonable restriction. I imagine in the most
common case at least they will be exact clones.
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
