mirror of
https://github.com/pacnpal/thrilltrack-explorer.git
synced 2025-12-20 07:11:12 -05:00
915a9fe2df
Implements edge function, Django tasks, and UI hooks/panels for automatic retention of old metrics, anomalies, alerts, and incidents, plus updates to query keys and monitoring dashboard to reflect data-retention workflows.
7 lines
430 B
SQL
7 lines
430 B
SQL
-- Fix security warnings: Set search_path for all retention policy functions
|
|
|
|
ALTER FUNCTION cleanup_old_metrics(INTEGER) SET search_path = public;
|
|
ALTER FUNCTION cleanup_old_anomalies(INTEGER) SET search_path = public;
|
|
ALTER FUNCTION cleanup_old_alerts(INTEGER) SET search_path = public;
|
|
ALTER FUNCTION cleanup_old_incidents(INTEGER) SET search_path = public;
|
|
ALTER FUNCTION run_data_retention_cleanup() SET search_path = public; |