Re: BUG #1307: Possible bug inheritance/referential integrity

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/