select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Compatibility

pg_dbms_lock

Extension to add Oracle DBMS_LOCK full compatibility to PostgreSQL

pgext.cloud · Source code · License text · Control file

Overview

Packagepg_dbms_lock
Version2.0
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryMultiple repositories
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemadbms_lock
Stars6
Latest commit2026-06-17
Latest release2026-06-17
Catalogue updated2026-08-30

Related extensions

Requires

pg_backgroundRun SQL queries in the background

See also

pg_dbms_jobExtension to add Oracle DBMS_JOB full compatibility to PostgreSQL
pg_dbms_metadataExtension to add Oracle DBMS_METADATA compatibility to PostgreSQL
pg_utl_smtpOracle UTL_SMTP compatibility extension for PostgreSQL
pg_dbms_errlogEmulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.
orafceFunctions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pg_cronJob scheduler for PostgreSQL
pgagentA PostgreSQL job scheduler
pg_taskexecute any sql command at any specific time at background