Обсуждение: Does 'ALTER INDEX' take exclusive lock?

Поиск
Список
Период
Сортировка

Does 'ALTER INDEX' take exclusive lock?

От
"Gurjeet Singh"
Дата:
Hi All,<br /><br />   Does the command ALTER INDEX take exclusive lock on the objects involved? Specifically I am
lookingat ALTER INDEX ... SET TABLESPACE. The docs do not mention anything about this. I assume it would, and can do a
fewtests (or look at code :) ), but asking here wouldn't hurt!<br /><br />Best regards,<br />-- <br
/>gurjeet[.singh]@EnterpriseDB.com<br/>singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com<br /><br
/>EnterpriseDB<a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br /><br />Mail sent from my
BlackLaptopdevice