PRIMARY KEY and INHERITANCE

From: Ferruccio Zamuner <nonsolosoft(at)diff(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: PRIMARY KEY and INHERITANCE
Date: 2000-12-31 14:42:00
Message-ID: 200012311442.eBVEfxC11641@tnt.diff.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oliver Elphick 2000-12-31 19:13:35 Re: PRIMARY KEY and INHERITANCE
Previous Message Patrick Welche 2000-12-31 14:18:19 Re: GNU readline and BSD license