Re: Auto Partitioning

Hi,

Andrew Dunstan wrote:
> I guess my point was really that multi-table indexes might have uses
> beyond partitioning.

Aha, now I understand. Thanks for the clarification.

> Say I have two tables, each with a field FKed to a field in a third
> table. I'd like to create the values to be unique across the referring
> tables. Now, there are various tricks that can be played either with
> custom triggers or redundant data to do this, but there's no easy way.
> However, a multi-table unique index would do it for me quite nicely, if
> we could create such a thing.

Maybe going into a similar direction and better think of it as a
multi-table uniqueness constraint, which internally uses multiple,
single-table indexes?

Regards

Markus