Re: inheritance vs 1-1 relationship
От | Reece Hart |
---|---|
Тема | Re: inheritance vs 1-1 relationship |
Дата | |
Msg-id | 1053385235.5829.1247.camel@tallac обсуждение исходный текст |
Ответ на | inheritance vs 1-1 relationship ("culley harrelson" <culley@ml1.net>) |
Список | pgsql-general |
On Sat, 2003-05-17 at 21:36, culley harrelson wrote: > Are there any drawbacks to > inheritance other than a decrease in portability? Inheritance is very nifty and, more importantly, better represents the data of some problems. I love it. James Gregory and I have just had a short thread re: foreign keys into inherited tables which you may wish to read (see archive). It's not a problem per se, but rather a minor shortcoming (IMO). Some things to note with inheritance: - indices are not created on subtable columns automatically - the super- & subtables are distinct tables - select really just does a union select on subtables - alter and drop cascade to subtables I haven't had any problems with inheritance and mostly think it's wonderful. -Reece -- Reece Hart, Ph.D. rkh@gene.com, http://www.gene.com/ Genentech, Inc. 650/225-6133 (voice), -5389 (fax) Bioinformatics and Protein Engineering 1 DNA Way, MS-93 http://www.in-machina.com/~reece/ South San Francisco, CA 94080-4990 reece@in-machina.com, GPG: 0x25EC91A0
В списке pgsql-general по дате отправления: