| From: | Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com> |
|---|---|
| To: | Saret Sout <saretsout(at)gmail(dot)com> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: What DBMS_LOCK? |
| Date: | 2014-02-28 04:38:49 |
| Message-ID: | CADp-Sm7kBE1wg0GtZh-QmSzYx4_UDFbv91oGaV-rXYEDyEUf6g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thu, Feb 27, 2014 at 9:13 PM, Saret Sout <saretsout(at)gmail(dot)com> wrote:
> Dear Community!
>
> Do you know about DBMS_LOCK on oracle? What is the main purpose of it?
>
AFAIK, DBMS_LOCK in Oracle are used for taking locks on devices e.g.
printer, screen etc.
> How about postgresql ?Does postgresql has DBMS_LOCK?
>
Where do you want to use it? It was apt for those days when people did not
had very powerful programming language and whole application was written
within database.
If it doesn't have how can we implement like DBMS_LOCK in oracle? Please
> help me to explain this issue. Thank
>
Again can you explain if you need above feature?
If you looking for simple "explicit lock on object" here is the place to
look for:
http://www.postgresql.org/docs/9.1/static/explicit-locking.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2014-02-28 07:34:17 | Re: What DBMS_LOCK? |
| Previous Message | Saret Sout | 2014-02-27 13:13:47 | What DBMS_LOCK? |