Does 'ALTER INDEX' take exclusive lock?

Started by Gurjeet Singhover 17 years ago1 messages
#1Gurjeet Singh
singh.gurjeet@gmail.com

Hi All,

Does the command ALTER INDEX take exclusive lock on the objects involved?
Specifically I am looking at ALTER INDEX ... SET TABLESPACE. The docs do not
mention anything about this. I assume it would, and can do a few tests (or
look at code :) ), but asking here wouldn't hurt!

Best regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device