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