PRIMARY KEY and INHERITANCE

Поиск
Список
Период
Сортировка
От Ferruccio Zamuner
Тема PRIMARY KEY and INHERITANCE
Дата
Msg-id 200012311442.eBVEfxC11641@tnt.diff.org
обсуждение исходный текст
Ответы Re: PRIMARY KEY and INHERITANCE  ("Oliver Elphick" <olly@lfix.co.uk>)
Re: PRIMARY KEY and INHERITANCE  (Horst Herb <hherb@malleenet.net.au>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [DOCS] Inheritance docs error.
Следующее
От: "Oliver Elphick"
Дата:
Сообщение: Re: PRIMARY KEY and INHERITANCE