A bunch of trigger functions to help establish and/or maintain referential integrity for columns that reference PostgreSQL ROLE NAMEs.
pgext.cloud · Source code · Documentation · Control file · PGXN
| Package | pg_role_fkey_trigger_functions |
|---|---|
| Version | 1.0.4 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 4 |
| Latest commit | 2025-05-24 |
| Latest release | 2025-05-25 |
| Catalogue updated | 2026-08-30 |
| pg_idm | Exposes PostgreSQL role and membership management through updatable views and DML-trigger functions. |
| time_for_keys | C and PL/pgSQL helpers that enforce temporal foreign keys between valid-time tables with constraint triggers. |
| edb_foreignkeyconstraintmanager | Manage trigger-based foreign-key behavior for partitioned tables on EDB Postgres Advanced Server |
| drop_role_helper | Generates SQL to revoke all privileges held by a role in the current database. |
| set_user | similar to SET ROLE but with added logging |
| monitoring_role | Security-definer monitoring wrappers for a non-privileged role |
| pointsource@supabase_rbac | Role-Based Access Control for your Supabase project |
| custom_roles | Role-specific Supabase RLS tables and functions for managing user roles. |