pg_dbms_lock v2.0 is a maintenance release of a PostgreSQL extension that emulates Oracle's DBMS_LOCK package using PostgreSQL advisory locks. Key changes include compatibility with PostgreSQL 19 and updated support for the pg_background v2+ API. Note that this version breaks compatibility with pg_background prior to v2.0. The extension implements ALLOCATE_UNIQUE(), REQUEST(), RELEASE(), and SLEEP() stored procedures, covering most of Oracle's DBMS_LOCK functionality except DBMS_LOCK.CONVERT() and some unsupported lock modes. It is maintained by HexaCluster under the PostgreSQL license.
2.6K Impressions