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