On Sat, Nov 06, 2004 at 12:11:49PM +0000, PostgreSQL Bugs List wrote: > > Rows inserted into a table "sub" inherited from a table > "super" do not seem to exist in the super-table from the point of > view of the foreign key constraint checker in references to the > "super"-table, even though a SELECT query displays the rows that > were inserted into sub also in super, as should be (See example > provided).
This is a known problem -- see the last paragraph in the "Inheritence" chapter of the PostgreSQL documentation: http://www.postgresql.org/docs/7.4/static/ddl-inherit.html The doc for 8.0 (in beta) has more detail: http://developer.postgresql.org/docs/postgres/ddl-inherit.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
