On Fri, May 06, 2005 at 01:51:45PM -0700, Aaron Steele wrote: > 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
You need to alter table Fooey to add fooid as UNIQUE NOT NULL or PRIMARY KEY. Then is will work fine. See also: http://www.varlena.com/GeneralBits/106.php --elein > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
