Inherited tables

On a recent thread Stephan Szabo mentioned some issues with inheritance.

***********

On Thu, 19 Feb 2004, Stephan Szabo wrote:

There are two separate things here that are gotchas
The first is that unique constraints don't inherit, and foreign keys must
refer to a unique constraint.

These are both deficiencies in inheritance and the constraints in
question.

***********

Anyone could comment on those problems?
I am working on a design which will heavily use inherittance and I think
on the long run the limitations above could make things to be more work
for me.

I would be willing to put some money forward to have someone work on
improving those limitations. Anyone knows who may be a good candidate to
work on this?