Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_try_advisory_lock is waiting? - Mailing list pgsql-general

From Michael Lewis
Subject Re: pg_try_advisory_lock is waiting?
Date
Msg-id CAHOFxGrTpz9SGxJnge2oS5mnRAhc658Q57VWU+yzdvonmjxhdQ@mail.gmail.com
Whole thread Raw
In response to pg_try_advisory_lock is waiting?  (Mladen Gogala <gogala.mladen@gmail.com>)
List pgsql-general
Tree view
pg_try_advisory_lock and other advisory lock functions take a lock on a key. The keys you have tried to lock are 0 and 1. Why?

What problem are you trying to solve by changing from "for update" lock to advisory lock anyway?

pgsql-general by date:

Previous
From: Mladen Gogala
Date:
Subject: pg_try_advisory_lock is waiting?
Next
From: Tom Lane
Date:
Subject: Re: pg_try_advisory_lock is waiting?