Allow confirming/conflicting index creation within a transaction

Allow confirming index creation inside a transaction, but fail for cases where we'd actually have to acquire a MODE_X lock.