pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stuart <sfbarbee@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: referencial conlumn contraints and inheritance
Date: Sun, 14 Oct 2001 07:28:31 -0400
Message-ID: <20011014112832.02352E83@station1.osa.org> (raw)

Folks,

  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:

create table areas (
area_id char(10) primary key,
name varchar(40),
.
description varchar(120) );

create table countries (
.
. ) inherits (areas);

create table states (
. 
country_id char(10) references countries ...,
.
. ) inherits (areas);

create table cities (
. 
country_id char(10) references countries ...,
.
.) inherits (areas);

Then a destination table set up with a field referencing areas. 
Currently postgres appears not to support reference contraints checking
through inherited tables.  Nor does it appear to support subselects in check
constraints.  It would be nice to allow reference checking through the
inherited tables so destination.area_id would be valid for any country,
state, or city area_id entered.

create table destination (
. 
area_id char(10) references areas ...,
.
.);

Thanks,

Stuart



view thread (4+ messages)  latest in thread

Message-ID: <20011014112832.02352E83@station1.osa.org>
Permalink:  ../20011014112832.02352E83@station1.osa.org/
Also on:    postgresql.org/message-id/20011014112832.02352E83@station1.osa.org

 · 

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: sfbarbee@yahoo.com
  Subject: Re: referencial conlumn contraints and inheritance
  In-Reply-To: <20011014112832.02352E83@station1.osa.org>

* 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