Error on reference to inherited primary key
Rene Pijlman <rpijlman@spamcop.net>
From: rpijlman@spamcop.net
To: pgsql-bugs@postgresql.org
Date: 2001-04-13T22:40:56Z
Lists: 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.