Обсуждение: Transaction-level advisory lock unlocking and transaction end

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

Transaction-level advisory lock unlocking and transaction end

От
Saimon Lim
Дата:
Hi,

I could not understand on the basis of documentation about transaction-level advisory lock:

> Transaction-level lock requests ... are automatically released at the end of the transaction ...

  So, what order will the use of transactions and unlock the lock?
The transaction would be applied at first and the lock would be unlocked after it or vice versa?
Or any order in this case is not guaranteed?

Thanks a lot for your help.
Saimon

Re: Transaction-level advisory lock unlocking and transaction end

От
Tom Lane
Дата:
Saimon Lim <aimon.slim@gmail.com> writes:
>> Transaction-level lock requests ... are automatically released at the end
>> of the transaction ...

>   So, what order will the use of transactions and unlock the lock?
> The transaction would be applied at first and the lock would be unlocked
> after it or vice versa?
> Or any order in this case is not guaranteed?

Locks are always released after the transaction has committed.

            regards, tom lane