Error on reference to inherited primary key - Mailing list pgsql-bugs

From rpijlman@spamcop.net
Subject Error on reference to inherited primary key
Date
Msg-id 200104132240.f3DMeuW41447@shelob.julianhaight.com
Whole thread Raw
Responses Re: Error on reference to inherited primary key
List pgsql-bugs
Creating tables this way:

   A has a primary key
   B inherits A
   C references B

results in an error message on the CREATE TABLE for C (ERROR:  PRIMARY KEY for referenced table "b" not found).

To reproduce:

create table A
(
    id integer primary key
);

create table B
(
    dummy integer
) inherits (A);

create table C
(
    ref integer references B
);

psql:repro.sql:14: ERROR:  PRIMARY KEY for referenced table "b" not found

AFAIK the SQL code is correct. B should inherit the primary key from A, so C should be able to reference B.

The workaround appears to be explicitly naming the primary key column:
create table C
(
    ref integer references B(id)
);

I'm using PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Compiling PG 7.0.3 undex HP-UX 10.20
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Homepage images do not set ALT attribute