inheritance vs 1-1 relationship

From: "culley harrelson" <culley(at)ml1(dot)net>
To: "pg-general" <pgsql-general(at)postgresql(dot)org>
Subject: inheritance vs 1-1 relationship
Date: 2003-05-18 04:36:33
Message-ID: 20030518043634.05A4B61569@smtp.us2.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Inheritance seems pretty nifty. I am at a point where I would normall
create a 1-1 relation ship where the primary key of a table is also a
foreign key on another table but it seems like inheritance would
essentially do the same thing + save me from having to write joins in my
selects and having to do 2 part inserts. Are there any drawbacks to
inheritance other than a decrease in portability?

culley

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-05-18 08:51:43 An interesting document? May be in non-traditional way
Previous Message Martijn van Oosterhout 2003-05-18 01:47:40 Re: Query changes