Обсуждение: About postgresql pg_advisory_xact_lock use!!!!

Hello All:

    When I use the pg_advisory_xact_lock provided by postgresql, I often see that the lock part cannot be released and
theservice is blocked. I would like to know what situations might cause this behavior. Thank you!!! 

Your’s Andy

andy ye <andy.ye@gtssz.net> writes:
>     When I use the pg_advisory_xact_lock provided by postgresql, I often see that the lock part cannot be released
andthe service is blocked. I would like to know what situations might cause this behavior. Thank you!!! 

I'd say the odds are just about 100% that you're not closing the
transaction.  Transaction-scope advisory locks are managed exactly
like any ordinary lock in the system, so if we had a bug that allowed
them to not be released at transaction end, there would be obvious
consequences everywhere.

            regards, tom lane