Обсуждение: Timeout for lock table

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

Timeout for lock table

От
"Jonathan Man"
Дата:
Dear All,
 
I begin a transaction. I then execute a SQL command "SELECT FOR UPDATE" to lock some records on the first session. Besides, I also lock some rows using the same method on the second session. Is it possible to return an error message to indicate that some records were locked by another user when I lock it on the second session?
 
Please help me, THX!!
 
 
JMAN