Postgres Pro
Downloads
Home   >   mailing lists

Re: primary key in table hierarchy - Mailing list pgsql-general

From David Garamond
Subject Re: primary key in table hierarchy
Date
Msg-id 4062F23A.2020801@zara.6.isreserved.com
Whole thread Raw
In response to primary key in table hierarchy  (David Garamond <lists@zara.6.isreserved.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Michael Meskes
Date:
Subject: Re: Solaris ecpg program doesn't work - pulling my hair out!
Next
From: Shelby Cain
Date:
Subject: Memory usage during vacuum