On Friday 14 September 2007, Ketema Harris <ketema@xxxxxxxxxx> wrote: > as expected I can do select * from states and get everything out of > the child table as well. What I can't do is create a FK to the > states table and have it look in the child table as well. Is this on > purpose? Is it possible to have FK that spans into child tables? No. -- The only difference between conservatives and liberals regarding budget cuts is tense. Conservatives say they will cut the budget, and then they increase it. After the budget has increased, liberals say that it has been cut. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq