From: | HexaCluster via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
---|---|
To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
Subject: | pg_dbms_lock v1.0 released |
Date: | 2023-12-05 12:39:33 |
Message-ID: | 170177997338.398197.3820551609875286088@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-announce |
Toronto, Canada - December 03, 2023
## PostgreSQL pg_dbms_lock extension
This PostgreSQL extension provided compatibility with the DBMS_LOCK Oracle package except the `DBMS_LOCK.CONVERT()` function and some unsupported lock modes who anyway are rarely found in the Oracle PL/SQL stored procedures.
The following stored procedures are implemented:
* `ALLOCATE_UNIQUE()`: Allocates a unique lock ID to a named lock.
* `REQUEST()`: Requests a lock of a specific mode.
* `RELEASE()`: Releases a lock.
* `SLEEP()`: Puts a procedure to sleep for a specific time.
For instance, user locks can be used to do the following:
* Provide exclusive access to an external device or service (like a printer).
* Coordinate or synchronize parallelized applications.
* Disable or enable execution of programs at specific times.
* Detect whether a session has ended a transaction using COMMIT or ROLLBACK.
This is the initial release of this exention.
## Links & Credits
Any contribution to build a better tool is welcome. You can send your ideas, features requests or patches
using the GitHub tools.
**Links :**
* Download: [https://github.com/hexacluster/pg_dbms_lock/releases/](https://github.com/hexacluster/pg_dbms_lock/releases/)
* Support: use GitHub report tool at [https://github.com/hexacluster/pg_dbms_lock/issues](https://github.com/hexacluster/pg_dbms_lock/issues)
* Documentation: [https://github.com/hexacluster/pg_dbms_lock#readme](https://github.com/hexacluster/pg_dbms_lock#readme)
## About pg_dbms_lock
The pg_dbms_lock extension is an original work at [HexaCluster Corp](https://hexacluster.ai/), Gilles Darold and Akhil Reddy Banappagari are the authors and the official maintainers.
From | Date | Subject | |
---|---|---|---|
Next Message | Greenmask.io via PostgreSQL Announce | 2023-12-05 19:28:55 | Greenmask Beta Release |
Previous Message | Yandex via PostgreSQL Announce | 2023-12-05 12:37:48 | Stateless Postgres Query Router 1.0.0 released |