REFERENCES fails on derived classes

From: "J(dot) Michael Caine" <jmcaine(at)alum(dot)rpi(dot)edu>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: REFERENCES fails on derived classes
Date: 2001-06-03 05:05:21
Message-ID: 000a01c0ebea$ca46dc10$44c04242@SPECTAURISSW
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

the following works:

create table t1 (id serial primary key);
create table t2 (id serial primary key);
create table t12 (
t1_id int references t1(id) on delete cascade,
t2_id int references t2(id) on delete cascade
);

but the following does not:
create table t1d () inherits(t1);
create table t1d2 (
t1d_id int references t1d(id) on delete cascade,
t2_id int references t2(id) on delete cascade
);

i'm told:
ERROR: UNIQUE constraint matching given keys for referenced table t1d not
found

i'm working in postgresql 7.1 (i686-pc-linux-gnu)

hope this is a bug (and i'm not wasting your time) and easily verifiable,
j. michael caine

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-06-03 20:32:15 plpython: sys module doesn't know about _getframe
Previous Message Tom Lane 2001-06-01 20:56:20 Re: Trigger causes the server to crash with SEGV