Thread: primary key in table hierarchy

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).

--
dave

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