PostgreSQL: pg_dbms_lock v1.0 released

[NewsBot]

A new PostgreSQL blog post/announcement has been posted!

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 ...

Get the full details here: PostgreSQL: pg_dbms_lock v1.0 released