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?