select open change scope Open full search

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

Extensions / Administration

non_truncate

Disables TRUNCATE by raising an error from a ProcessUtility hook

pgext.cloud · Source code · Documentation · Control file

Overview

Packagenon_truncate
Version1.0
PostgreSQL versions13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableYes
Shared librariesnon_truncate
Stars1
Latest commit2021-02-19
Catalogue updated2026-08-30

Related extensions

See also

ddl_replReplicate DDL and DCL commands across PostgreSQL instances by means of a utility hook
track_renamesEvent-trigger function that forwards PostgreSQL object rename details to a configurable callback.
ddl_versioningDDL object versioning with event triggers for tables, indexes, functions, and views.
implicit_schemaEvent-trigger extension that automatically creates a schema when a table or view is created in a missing schema.
pg_dbo_timestampPostgreSQL extension for storing time and author of database structure modification.
ddlaAudit DDL changes with event triggers and queryable log functions
schema_triggersArchived C hook extension adding relation, column, and trigger schema-change events to PostgreSQL event triggers.
pg_catalog_get_defsAdds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata.