Re: [HACKERS] Re: [QUESTIONS] using composite types

> What you want to do can probably be accomplished with inheritance, but
> that only seems to work if you have unique names for more of your
> fields:
>
> create table A ( a int, b int);
> create table D ( c int) inherits (A);
>
> But, if you try
>
> create table D ( b int) inherits (A);
>
> then the new column in D gets lost without warning!

Patient: Ow, doctor, it hurts when I do this.
Doctor: Well, then don't do that.

---------------------------------------------------------------------------

This is a pretty bizarre example, and I am not sure how the system will
handle this. My guess is that it finds only the first b. Seems like we
need a check somewhere when making inheritance. I will add it to the
TODO.

* disallow inherited columns with the same name as new columns

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)