Hi,
I want to reference an inherited table:
- - - Schnipp - - -
create table parent
(
id serial,
primary key(id)
);
create table child
(
thing integer
) inherits (parent);
create table third
(
stuff integer references child
);
- - - Schnapp - - -
But get an error:
ERROR: PRIMARY KEY for referenced table "child" not found
Is there a way to do it or do I have to reference parent?
tia,
Thorsten
--
Auch Hunger ist Krieg.
- Willy Brandt