Re: INHERITS doesn't offer enough functionality

Chris wrote:

> It's pretty clear to me that an inherited index should be only one
> index. There may be a case for optional non-inherited indexes (CREATE
> INDEX ON ONLY foobar), but if the index is inherited, it is just one
> index.
>
> At the end of the day though, the reason is only performance. The
> semantics should be the same no matter whether implemented as multiple
> indexes or not. Performance is much better with one index though.(*)
>

Is it true ?
How to guarantee the uniqueness using multiple indexes ?

Regards.
Hiroshi Inoue