Advertisement
Guest User

Untitled

a guest
May 2nd, 2016
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. keith@pgods=# select pg_try_advisory_lock(hashtext('summarize_hits_today'));
  2. pg_try_advisory_lock
  3. ----------------------
  4. f
  5. (1 row)
  6.  
  7. Time: 1.005 ms
  8. keith@pgods=# select pg_advisory_unlock(hashtext('summarize_hits_today'));
  9. WARNING: you don't own a lock of type ExclusiveLock
  10. pg_advisory_unlock
  11. --------------------
  12. f
  13. (1 row)
  14.  
  15. Time: 0.528 ms
  16. keith@pgods=# select pg_try_advisory_lock(hashtext('summarize_hits_today'));
  17. pg_try_advisory_lock
  18. ----------------------
  19. f
  20. (1 row)
  21.  
  22. Time: 0.578 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement