Search Postgresql Archives

Re: Drop/ Alter index if exist

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



thanks

2009/12/22 Filip Rembiałkowski <plk.zuber@xxxxxxxxx>


2009/12/22 Pau Marc Munoz Torres <paumarc@xxxxxxxxx>

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)


--
Filip Rembiałkowski
JID,mailto:filip.rembialkowski@xxxxxxxxx
http://filip.rembialkowski.net/



--
Pau Marc Muñoz Torres

Laboratori de Biologia Computacional  
Institut de  Biotecnologia   i Biomedicina Vicent Villar                                    
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)
             
telèfon: 93 5812807
Email : paumarc.munoz@xxxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux