Re: Reference to Inherited Table

Hi,

>create table third
>(
>     stuff integer references child
>);
>- - - Schnapp - - -
>But get an error:
>ERROR:  PRIMARY KEY for referenced table "child" not found

Try
create table third(
stuff integer references child(thing)
);

You could do what you were trying to do if in the child table you have a
field called 'stuff', but since you don't, you have to reference it
specifically.


-----------------
      Chris Smith
http://www.squiz.net/