Named advisory locks

From: rihad <rihad(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Named advisory locks
Date: 2011-04-05 09:42:45
Message-ID: 4D9AE415.6030205@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, all. I'm looking for a way to lock on an arbitrary string, just how
MySQL allows doing with GET_LOCK('foo.123') / RELEASE_LOCK('foo.123'). I
know that at least Postgres 8.3 has pg_advisory_lock() /
pg_advisory_unlock() but they seem to accept integer values only, and
we're already using integer values elsewhere.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-04-05 09:45:10 Re: Database "gnu make" equivalent
Previous Message Gabriele Bartolini 2011-04-05 09:18:02 Re: Database "gnu make" equivalent