Reference to Inherited Table - Mailing list pgsql-novice

From Thorsten Haude
Subject Reference to Inherited Table
Date
Msg-id 20020323123751.GA923@eumel.yoo.net
Whole thread Raw
Responses Re: Reference to Inherited Table  (Chris <csmith@squiz.net>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: John Taylor
Date:
Subject: Re: Visio ODBC winnt Linux question
Next
From: Richard A Lough
Date:
Subject: Re: Estimating Database Disk Space