Transaction-level advisory lock unlocking and transaction end

Поиск
Список
Период
Сортировка
От Saimon Lim
Тема Transaction-level advisory lock unlocking and transaction end
Дата
Msg-id CAOkVcQ6RcedhjBn2LGF9SmNdf9A+gi__kOgBcwr0L6DLdNOEFQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Transaction-level advisory lock unlocking and transaction end  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
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

В списке pgsql-general по дате отправления:

Предыдущее
От: sambsa
Дата:
Сообщение: pgagent jobs Could not connect to the database !
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: can you have any idea about toast missing chunk issu resolution