lock
lock copied to clipboard
PostgreSQL lock should support timeout
use pg_try_advisory_lock instead of pg_advisory_lock
supported since locks were introduced in PostgreSQL - https://www.postgresql.org/docs/8.2/functions-admin.html