I'm running into a problem where I have to create an index with a name
that doesn't conflict with any existing index.
Currently, its not possible to do in postgres.
It'd be nice if either of 3 were implemented:
1) alter index to rename it
2) alter table would rename index with some option(?)
3) index namespace should be constricted to the table on which it is
indexed, since no commands to my knowledge manipulate the index without
also specifying the table. I.E. in such a way, I will have index a on
table foo, and index a on table bar without a conflcit.
Is there a specification of current postgres behaviour anywhere in SQL
standard? (i.e. index namespace being global?)
-alex