From: | Horst Herb <hherb(at)malleenet(dot)net(dot)au> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | PLEASE help with foreign key and inheritance problem |
Date: | 2000-12-13 11:34:27 |
Message-ID: | 00121322342706.03185@munin.midgard |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I stated this before, but I did not get a helpful answer. I might have
misunderstood tghe documentation on foreign keys:
create table global(id serial);
create table child(anything text) inherits(global);
insert into child(anything) values ('test);
Now, a select * from child shows
id anything
-------------
1 test
So far, so good.
create table dependend(globid int4 references child(id) on update cascade on
delete cascade);
gives me an error:
CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR: UNIQUE constraint matching given keys for referenced table "child"
not found
Once again, _why_ is this? What would inheritance be good for if I can't use
it this way? Bad enough that inheritance of triggers or constraints doesn't
work, but a simple refernce to a attribute should be possible, shouldn't it?
If there is a good reason not to allow it, I would like to know. If not, I
would be willing to help out implementing it, if somebody points me into the
right direction in the code (or documentation)
Horst
From | Date | Subject | |
---|---|---|---|
Next Message | Oleg Bartunov | 2000-12-13 11:46:15 | Re: Locale and multibyte support in 7.1 |
Previous Message | Anatoly K. Lasareff | 2000-12-13 11:06:16 | Locale and multibyte support in 7.1 |