Re: About postgresql pg_advisory_xact_lock use!!!!

andy ye <[email protected]> writes:
> 	When I use the pg_advisory_xact_lock provided by postgresql, I often se=
e that the lock part cannot be released and the service is blocked. I woul=
d 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