Re: pg_try_advisory_lock is waiting?

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_try_advisory_lock is waiting?
Date: 2022-01-28 23:14:40
Message-ID: CAHOFxGrTpz9SGxJnge2oS5mnRAhc658Q57VWU+yzdvonmjxhdQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2022-01-29 00:08:14 Re: pg_try_advisory_lock is waiting?
Previous Message Mladen Gogala 2022-01-28 23:05:18 pg_try_advisory_lock is waiting?