PG Bug reporting form <noreply@postgresql.org> writes: > Function "pg_try_advisory_xact_lock" triggers a WARNING message when the > lock is already owned by someone else.
I failed to duplicate this behavior. I did this in session A:
regression=# begin; BEGIN regression=*# select pg_try_advisory_xact_lock(1); pg_try_advisory_xact_lock --------------------------- t (1 row)
then this in session B:
regression=# select pg_try_advisory_xact_lock(1); pg_try_advisory_xact_lock --------------------------- f (1 row)