pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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







view thread (4+ messages)  latest in thread

Message-ID: <web-147570@davinci.ethosmedia.com>
Permalink:  ../web-147570@davinci.ethosmedia.com/
Also on:    postgresql.org/message-id/web-147570@davinci.ethosmedia.com

 · 

reply

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