Again about foreign keys and inheritance

Hi all.

Does the problem of accessing an whole inheritance's tree via foreign key resolved?

The problem is:
in next example an insert into table roaming will fail. Can I solve it anyway?
Without foreign keys on parent tables IMHO inheritance is meaningless...

Dedov Anton

EXAMPLE:

create table devs (
devid int,
owner int,
devtype varchar,

primary key (devid) --,
-- foreign key (owner) references ab,
-- foreign key (devtype) references devtypes
);

create table roaming (
dev int,
node int,
validto timestamp,

primary key (dev, node),
foreign key (dev) references devs --,
-- foreign key (node) references nodes
);

create table devs_pocsag (
capcod int unique not null check (capcod > 0),
subcod int not null check (subcod >= 0),
speed int not null,
freq float4 not null,
ptype varchar not null,
is_inv boolean default 'f',

primary key (devid) --,
-- foreign key (speed) references pocsag_speeds,
-- foreign key (ptype) references pocsag_ptypes,
-- foreign key (freq) references pocsag_freqs
) inherits (devs);

--...

select * from devs_pocsag;
devid | owner | devtype | capcod | subcod | speed | freq | ptype | is_inv
-------+--------+---------+--------+--------+-------+-------+------------+--------
0 | 240008 | POCSAG | 240008 | 0 | 1200 | 159.2 | Millennium | f

insert into roaming (dev,node) values (0,95);
ERROR: <unnamed> referential integrity violation - key referenced from roaming not found in devs