Bug list?

Hi,

I [think I] found a bug, and tried to send a report to pgsql-bugs and it
never showed up there.

The *very brief* version:

I have a hierarchy of tables using Postgres's inheritance feature. In the
root table I have a serial type which is a primary key. Another table (not
in the hierarchy) has a foreign key to the primary key of the top table in
the hierarchy.

When I insert a record with a foreign key that references an object in a
descendent table, I get a referential integrity error. But when it
references an item that is simply a member of the top class, no problem - the
foreign key works then.

If I select * from the top class, both records show up, along with their id
primary key. So why can't a foreign key refer to the one that is a member of
a subclass?

I'm using 7.1.2

Thanks,
Micah

--
Like to travel? http://TravTalk.org
Micah Yoder Internet Development http://yoderdev.com