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
parenttables 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