============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Ernest E Vogelsinger
Your email address : ernest@vogelsinger.at
System Configuration
---------------------
Architecture (example: Intel Pentium) : 2 x Intel Pentium 4
Operating System (example: Linux 2.0.26 ELF) : Linux version 2.4.9-34smp
(bhcompile@daffy.perf.redhat.com)
(gcc version 2.96 20000731
(Red Hat Linux 7.2 2.96-108.1))
#1 SMP Sat Jun 1 06:15:25 EDT 2002
PostgreSQL version (example: PostgreSQL-7.2.1): PostgreSQL-7.2.1
Compiler used (example: gcc 2.95.2) : RedHat RPM
Please enter a FULL description of your problem:
------------------------------------------------
There is a severe problem with foreign keys that are inherited:
RI is NOT enforced on inherited foreign keys.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
create table tb1 (
id serial primary key
);
create table tb2 (
id serial primary key,
id_tb1 integer references tb1(id),
id_tb2 integer references tb2(id)
);
create table tb2a (
data varchar
) inherits(tb2);
-- these two return an error (correct)
insert into tb2(id_tb1) values (999);
insert into tb2(id_tb2) values (999);
-- but these two work (WRONG!!)
insert into tb2a(id_tb1) values (999);
insert into tb2a(id_tb2) values (999);
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
Sorry, no idea :) but it certainly needs to be fixed...
>O Ernest E. Vogelsinger
(\) ICQ# 13394035
^