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

Tue, 12 Dec 2000 23:37:43 +1100
Horst Herb <hherb@malleenet.net.au>
HELP! foreign eys & inheritance

> btw anyone trying this query should use: "attdispersion"
> 

I see it, yes. Was this an intended change ? I am quite sure, that it was 
attdisbursion in 7.0 ?

Andreas

Tue, 12 Dec 2000 13:59:40 +0100
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
AW: SourceForge & Postgres (attdispursion)
> I see it, yes. Was this an intended change ? I am quite sure, that it was 
> attdisbursion in 7.0 ?

Yes, I couldn't spell dispersion in the past.  :-)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 12 Dec 2000 09:01:21 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: AW: SourceForge & Postgres (attdispursion)