select open change scope Open full search

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

Extensions / Compatibility

pg_dbms_errlog

Emulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.

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

Overview

Packagepg_dbms_errlog
Version2.4
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryMultiple repositories
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableNo
Shared librariespg_dbms_errlog
Schemadbms_errlog
Stars16
Latest commit2026-06-23
Latest release2026-06-23
Catalogue updated2026-08-30

Related extensions

Requires

pg_statement_rollbackServer side rollback at statement level for PostgreSQL like Oracle or DB2

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_lockExtension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
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