I had meant to send this to the list as well.
--- Forwarded Message
Date:Fri, 22 Dec 2000 23:13:56 +
From:"Oliver Elphick" <[EMAIL PROTECTED]>
To: Tom Lane <[EMAIL PROTECTED]>
Subject: Re: [HACKERS] RI problem with inherited table
Tom Lane wrote:
"Oliver Elphick" <[EMAIL PROTECTED]> writes:
> It no longer seems to be possible to refer to a table, which is an
> ancestor of any other, in a referential integrity constraint.
> bray=# create table junk (id char(10) constraint junk_id_person references
> person(id));
> NOTICE: CREATE TABLE wi
It no longer seems to be possible to refer to a table, which is an
ancestor of any other, in a referential integrity constraint.
In this example, "person" is the ancestor of several other tables:
bray=# create table junk (id char(10) constraint junk_id_person references
person*(id));
ERROR: p
