renaming indices?
| От | Alex Pilosov |
|---|---|
| Тема | renaming indices? |
| Дата | |
| Msg-id | Pine.BSO.4.10.10101161848180.23551-100000@spider.pilosoft.com обсуждение исходный текст |
| Ответы |
Re: renaming indices?
|
| Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: