PostgreSQL
Read post

pg_dbms_lock v2.0 has been released

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.

    #postgresql
Jul 05•2m read time•From postgresql.org
Post cover image
Table of contents
PostgreSQL DBMS_LOCK compatibility extensionLinks & CreditsAbout pg_dbms_lock
2.6K Impressions
PostgreSQL's image
PostgreSQL

PostgreSQL blogs and resources offer developers insights into PostgreSQL database management, admini...

601 Followers

•

1.4K Upvotes

Would you recommend this post?

Copy link
WhatsApp
Facebook
X
New Squad
  • © 2026 Daily Dev Ltd.
  • Guidelines
  • Explore
  • Tags
  • Sources
  • Squads
  • Leaderboard