> > Because we just create a unique index on a PRIMARY specification, I
> > think any unique index on a field shows it as primary.
> Hmm. Any chance we can somehow flag it as well? Perhaps a new bool
> field in pg_index the next time we do a dump & reload release? I
> assume we will need it eventually anyway.
I'm not sure I understand all the issues, but if we can avoid
distinctions between different indices that would be A Good Thing. Since
multiple unique indices are allowed, what would be the extra
functionality of having one designated "primary"? Is it an arbitrary
SQL92-ism which fits with older databases, or something which enables
new and interesting stuff?
- Tom
