Re: What DBMS_LOCK?

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