select open change scope Open full search

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

Extensions / Features

pg_cache_tree

Caches recursive parent and child IDs in array columns using trigger and helper functions.

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

Overview

Packagepg_cache_tree
Version1.0.0
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars1
Latest commit2020-04-21
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

lpathtreeHierarchical path types using slash-separated labels
boolean_cascadedComposite boolean status type with operators and trigger helper for cascaded parent-child status.