C and PL/pgSQL helpers that enforce temporal foreign keys between valid-time tables with constraint triggers.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | time_for_keys |
|---|---|
| Version | 0.0.1 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 23 |
| Latest commit | 2018-07-09 |
| Catalogue updated | 2026-08-30 |
| plpgsql | PL/pgSQL procedural language |
| temporal | C extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support. |
| pgsfti | PostgreSQL data type for simple trapezoidal fuzzy time intervals and fuzzy temporal relations. |
| temporal_tables | temporal tables |
| sql_saga | C and PL/pgSQL extension for valid-time temporal tables, temporal foreign keys, history-preserving views, and bulk temporal merge operations. |
| range_agg | range_agg: merge adjacent or overlapping PostgreSQL range values |
| lostgis | LostGIS spatial helper functions and types |
| pg_role_fkey_trigger_functions | A bunch of trigger functions to help establish and/or maintain referential integrity for columns that reference PostgreSQL ROLE NAMEs. |
| emaj | Enables fine-grained write logging and time travel on subsets of the database. |