Postgres Pro
Downloads
Home   >   mailing lists

Re: What DBMS_LOCK? - Mailing list pgsql-novice

From Thomas Kellerer
Subject Re: What DBMS_LOCK?
Date
Msg-id lepe5b$eem$1@ger.gmane.org
Whole thread Raw
In response to What DBMS_LOCK?  (Saret Sout <saretsout@gmail.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Override PostgreSQL internal functions
Next
From: ss dev
Date:
Subject: XML data