PRIMARY KEY and INHERITANCE

Ferruccio Zamuner <nonsolosoft@diff.org>

From: Ferruccio Zamuner <nonsolosoft@diff.org>
To: pgsql-hackers@postgresql.org
Date: 2000-12-31T14:42:00Z
Lists: pgsql-hackers
Hi,

some months ago I've asked for a suggestion for this bug:

create table a (
       id serial primary key,
       something text
);

create table b (
       morething text
) inherits (a);

create table c (
       trouble int references b;
);
NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
ERROR:  PRIMARY KEY for referenced table "b" not found


How is possible to resolve this bug?
How is possible to talk about a ORDBMS with this kind of error?

I've looked for workaround, but:

create table d (
       mytext text,
       primary key (id)
) inherits (a);
ERROR:  CREATE TABLE: column 'id' named in key does not exist

How can I help you to fix this?


Best wishes,             \fer