On 27 February 2014 13:13, Saret Sout <saretsout@gmail.com> wrote:
> Dear Community!
>
> 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? Please help me to explain this
> issue. Thank
You probably want to look at Advisory Locks
http://www.postgresql.org/docs/devel/static/functions-admin.html#FUNCTIONS-ADVISORY-LOCKS
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services