Re: inherit with foreign key reference

On Fri, May 06, 2005 at 01:51:45PM -0700, Aaron Steele wrote:
> dear readers,
>
> i've created a simple Fooey table that inherits from Foo:
> !----------------------------------------------------------!
> CREATE TABLE Foo(
> fooid serial UNIQUE,
> footype text);
> CREATE TABLE Fooey(
> data text);
> INHERITS(Foo);
> !----------------------------------------------------------!
>
> next i try to create a Bar table that references Fooey's fooid (inherited
> from Foo) as a foreign key:
> !----------------------------------------------------------!
> CREATE TABLE Bar(
> fooeyid int REFERENCES Fooey(fooid));
> !----------------------------------------------------------!
>
> unfortunately i get the following error:
> !----------------------------------------------------------!
> ERROR: there is no unique constraint matching given keys for referenced
> table "pagesrc"
> !----------------------------------------------------------!
>
> thoughts?
>
> thanks,
> aaron

You need to alter table Fooey to add fooid as UNIQUE NOT NULL
or PRIMARY KEY. Then is will work fine.

See also: http://www.varlena.com/GeneralBits/106.php

--elein

>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>