PRIMARY KEY and INHERITANCE
От | Ferruccio Zamuner |
---|---|
Тема | PRIMARY KEY and INHERITANCE |
Дата | |
Msg-id | 200012311442.eBVEfxC11641@tnt.diff.org обсуждение исходный текст |
Ответы |
Re: PRIMARY KEY and INHERITANCE
Re: PRIMARY KEY and INHERITANCE |
Список | 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 по дате отправления: