| From: | Mladen Gogala <mgogala(at)vmsinfo(dot)com> |
|---|---|
| To: | Zdravko Balorda <zdravko(dot)balorda(at)siix(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Table inheritance |
| Date: | 2010-03-26 15:15:39 |
| Message-ID: | 4BACCF9B.3010307@vmsinfo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Inheritance is not the replacement for foreign keys. Inheritance
mechanism is a sort of "create like" thing. Created table inherits
column names and types. Indexes and constraints are not inherited.
Foreign keys still have to be used to guarantee the logical consistency.
Zdravko Balorda wrote:
>
> Hi,
> I'm new to inheritance. Does anyone have a good link about it?
>
> I have just finished an application using parent and child tables.
> Tables look a bit strange. :)
>
> Inheritance seems a good replacement for foreign keys. One can
> completely forget about them which simplifies programming.
> A great idea, this inheritance.
>
> Regards, Zdravko
>
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Donn Washburn | 2010-03-26 18:59:16 | Re: Getting started |
| Previous Message | Zdravko Balorda | 2010-03-26 10:25:13 | Re: Table inheritance |