Regarding ALTER TABLE ADD INHERITS, tablecmds.c has the following comment for
when it's creating a table that inherits some columns:
* The order in which the attributes are inherited is very important.* Intuitively, the inherited attributes
shouldcome first. If a table* inherits from multiple parents, the order of those attributes are* according to
theorder of the parents specified in CREATE TABLE.
If you add a parent table at some later date then the columns might not fit
this constraint. Is it actually "very important" or merely a good idea for the
server to create them in the order the user will expect? That is, is anything
else in the server going to break if the columns aren't in the right order?
Actually now that I think of it removing a parent table can also create a
"incorrectly" ordered column list if the table has multiple parents. If we
remove one of its first parents and one of the columns was merged from
multiple parents then it will appear before its normal place with the other
columns from the later parent.
Incidentally, did the following message ever make it to the list? I saw my
carbon copy, but never received it from the list and never received any
responses. Usually any suggestion of making tokens reserved words elicits
screams of objections.
Greg Stark <gsstark@MIT.EDU> writes:
> 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
>
>
--
greg