Fwd: Re: HELP! foreign eys & inheritance - Mailing list pgsql-hackers

From Horst Herb
Subject Fwd: Re: HELP! foreign eys & inheritance
Date
Msg-id 00121301254004.03185@munin.midgard
Whole thread Raw
Responses Re: Fwd: Re: HELP! foreign eys & inheritance  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-hackers
Ooops, sorry, error in this example:
> 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 child(global_id) on update cascade on delete no

action                                 ^^^^^ child, of course, not parent!

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

-------------------------------------------------------


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: COPY BINARY file format proposal
Next
From: Barry Jenner
Date:
Subject: Re:Postgresql on dynix/ptx system