Re: inherit with foreign key reference

On Fri, 2005-05-06 at 15:51, 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"
> !----------------------------------------------------------!

Judging by the "pagesrc" error, it looks like you've edited the session
to remove any sensitive data, but in the doing may well have edited away
the evidence of the real problem.

What does the REAL session look like?