Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group