inherit with foreign key reference
От | Aaron Steele |
---|---|
Тема | inherit with foreign key reference |
Дата | |
Msg-id | 427BD8E1.3080205@berkeley.edu обсуждение исходный текст |
Ответы |
Re: inherit with foreign key reference
Re: inherit with foreign key reference Re: inherit with foreign key reference |
Список | pgsql-general |
dear readers, i've created a simple Fooey table that inherits from Foo: !----------------------------------------------------------! CREATE TABLE Foo( fooid serial UNIQUE, footype text); CREATE TABLE Fooey( data text); INHERITS(Foo); !----------------------------------------------------------! next i try to create a Bar table that references Fooey's fooid (inherited from Foo) as a foreign key: !----------------------------------------------------------! CREATE TABLE Bar( fooeyid int REFERENCES Fooey(fooid)); !----------------------------------------------------------! unfortunately i get the following error: !----------------------------------------------------------! ERROR: there is no unique constraint matching given keys for referenced table "pagesrc" !----------------------------------------------------------! thoughts? thanks, aaron
В списке pgsql-general по дате отправления: