Re: Drop/ Alter index if exist

Поиск

Список

Период

Сортировка

От	Filip Rembiałkowski
Тема	Re: Drop/ Alter index if exist
Дата	22 декабря 2009 г. 10:01:19
Msg-id	92869e660912220601h45113babx53d71fee47864100@mail.gmail.com обсуждение исходный текст
Ответ на	Drop/ Alter index if exist (Pau Marc Munoz Torres <paumarc@gmail.com>)
Ответы	Re: Drop/ Alter index if exist
Список	pgsql-general

2009/12/22 Pau Marc Munoz Torres <paumarc@gmail.com>

Hi every body

there is some way to delete or rename an index only if this index exists?

something like

"alter index index rename to pepe if exists"

for drop - yes:

DROP INDEX IF EXISTS name;

for rename - there is no simple solution. well, actually there are solutions but they are more complicated than the problem.

(think of user defined functions)

В списке pgsql-general по дате отправления: