Dapper Tutorial - Knowledge Base (KB)

How to use "Try" Postgres Advisory Locks

I am experiencing some unexpected (to me) behavior using pg_try_advisory_lock. I believe this may be connection pooling / timeout related....pg_advisory_lock is working as expected. When I call the function and the desired lock is already in use, my app...