Thread: PRIMARY KEY not found?

Here is the problem:

Table A ( id int, ...)
Table B ( ... ) inherits (A)

CREATE TABLE C ( id int REFERENCES B ON DELETE CASCADE, ...);

ERROR:  PRIMARY KEY for referenced table "B" not found

It is fine when the reference is table A.

Why?



____________________________________________________________
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005

On Sat, 2 Aug 2003, Vernon Smith wrote:

>
> Here is the problem:
>
> Table A ( id int, ...)
> Table B ( ... ) inherits (A)
>
> CREATE TABLE C ( id int REFERENCES B ON DELETE CASCADE, ...);
>
> ERROR:  PRIMARY KEY for referenced table "B" not found
>
> It is fine when the reference is table A.
>
> Why?

I'm guessing that table A has a primary key on id?
Primary keys are not currently inherited, so you need to define
the key on B as well (and it doesn't guarantee uniqueness between
A and B)