Re: primary key in table hierarchy

From: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: primary key in table hierarchy
Date: 2004-03-25 14:52:42
Message-ID: 4062F23A.2020801@zara.6.isreserved.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Garamond wrote:
> Is it possible now to have PK or unique key constraint accross the table
> hierarchy (i.e. given parent > child > grandchild, if record with PK=1
> is defined in child; PK=1 is forbidden in parent or grandchild).

Sorry for not reading the archives. I guess table inheritance is pretty
broken right now, ah well... back to the good old LEFT OUTER JOIN :-)

--
dave

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shelby Cain 2004-03-25 14:55:07 Memory usage during vacuum
Previous Message Mike Nolan 2004-03-25 14:45:40 Re: Adding flexibilty to queries