Adds advisory locks that are automatically released at the end of a transaction.