From: Josh Berkus <josh@agliodbs.com>
To: sfbarbee@yahoo.com
To: pgsql-sql@postgresql.org
Subject: Re: referencial conlumn contraints and inheritance
Date: Sun, 14 Oct 2001 11:54:10 -0700
Message-ID: <web-147570@davinci.ethosmedia.com> (raw)
In-Reply-To: <20011014112832.02352E83@station1.osa.org>
Stuart,
> I am not sure where to post this. This may be more of a wishlist
> item
> than a usage question. I am new to postgresql 7.1. Table
> inheritance
> in postgres seems wonderfull. Is there the capability now or any
> plans to extend support for inherited tables in column constraints.
> One
> example is a travel db where several tables are defined as:
There have been, as I understand it, several improvements made to
inheritance and constraints in 7.2 (released soon, really!).
However, you're potentially in for a world of painful workarounds here.
REFERENCES constraints are part of a Relational DBMS system; Inheritance
is an OODB concept. The two do not, IMHO, mix easily. Further, current
implementations of table inheritance are largely proprietary, meaning
that your application becomes impossible to part across platforms.
If I were designing your database, I would forget about inheritance, and
build it completely relationally, either with an tree-structured Areas
table keyed to area subtypes, or with heirarchical tables of country -->
region --> province --> city etc. Which structure you use depends
largely on the rest of the application.
However, keep in mind that a lot of people (the Postgres core team
included) do not agree with me about inheritance and its limitations.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, sfbarbee@yahoo.com
Subject: Re: referencial conlumn contraints and inheritance
In-Reply-To: <web-147570@davinci.ethosmedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox