renaming indices?

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: renaming indices?
Date: 2001-01-16 23:51:39
Message-ID: Pine.BSO.4.10.10101161848180.23551-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-01-17 00:06:20 Re: renaming indices?
Previous Message Tom Lane 2001-01-16 22:28:29 Re: SIGTERM -> elog(FATAL) -> proc_exit() is probably a bad idea