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/