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