Re: What DBMS_LOCK?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: What DBMS_LOCK?
Date: 2014-02-28 07:34:17
Message-ID: lepe5b$eem$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Saret Sout, 27.02.2014 14:13:
> Do you know about DBMS_LOCK on oracle? What is the main purpose of it?
> How about postgresql ?Does postgresql has DBMS_LOCK?
> If it doesn't have how can we implement like DBMS_LOCK in oracle?

I think the closest thing to DBMS_LOCK in Postgres are advisory locks:

http://www.postgresql.org/docs/current/static/explicit-locking.html#ADVISORY-LOCKS

Thomas

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Simon Riggs 2014-02-28 08:18:33 Re: What DBMS_LOCK?
Previous Message Sameer Kumar 2014-02-28 04:38:49 Re: What DBMS_LOCK?