Csaba Nagy <nagy@xxxxxxxxxxxxxx> writes: > With the "mess" you refer to the new index, and the fact it is > impossible to delete it if not possible to replace the old one ? I fail > to see why... you WILL get an exclusive lock, so you should be able to > delete the index. Consider the ALTER OWNER example ... regards, tom lane