> I stated this before, but I did not get a helpful answer. I
> might have
> misunderstood tghe documentation on foreign keys:
>
> create table global(id serial);
> create table child(anything text) inherits(global);
need:create unique index child_id_index on child (id);
> gives me an error:
> CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
> ERROR: UNIQUE constraint matching given keys for referenced
> table "child"
> not found
Then the above works.
Actually the error message sounds sufficiently clear to me, no?
Andreas
