Transaction-level advisory lock unlocking and transaction end

From: Saimon Lim <aimon(dot)slim(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Transaction-level advisory lock unlocking and transaction end
Date: 2015-01-15 16:16:31
Message-ID: CAOkVcQ6RcedhjBn2LGF9SmNdf9A+gi__kOgBcwr0L6DLdNOEFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2015-01-15 16:41:04 Re: Indexing large table of coordinates with GiST
Previous Message sambsa 2015-01-15 16:07:38 pgagent jobs Could not connect to the database !