HELP! foreign eys & inheritance

From: Horst Herb <hherb(at)malleenet(dot)net(dot)au>
To: pgsql-hackers(at)postgresql(dot)org
Subject: HELP! foreign eys & inheritance
Date: 2000-12-12 12:37:43
Message-ID: 00121223374300.03185@munin.midgard
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The following example worked in previous versions (7.0.2 was the last I
tested), but not in 7.1 any more:

create table parent (
global_id serial
);

create table child (
anything text
) inherits (parent);

create table foreign (
fk_id int4 references parent(global_id) on update cascade on delete no action
) inherits (parent);

test.sql:83: ERROR: UNIQUE constraint matching given keys for referenced
table "child" not found
WHY ???

I would appreciate any help. Our database depends heavily on this.

Horst

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB 2000-12-12 12:59:40 AW: SourceForge & Postgres (attdispursion)
Previous Message mlw 2000-12-12 12:17:00 Re: SourceForge & Postgres