aboutsummaryrefslogtreecommitdiffstats
path: root/scripts/entry_limit_trigger.pgsql
diff options
context:
space:
mode:
Diffstat (limited to 'scripts/entry_limit_trigger.pgsql')
-rw-r--r--scripts/entry_limit_trigger.pgsql19
1 files changed, 0 insertions, 19 deletions
diff --git a/scripts/entry_limit_trigger.pgsql b/scripts/entry_limit_trigger.pgsql
deleted file mode 100644
index d7d99c2..0000000
--- a/scripts/entry_limit_trigger.pgsql
+++ /dev/null
@@ -1,19 +0,0 @@
-CREATE OR REPLACE FUNCTION milla.janitor ()
- RETURNS TRIGGER
- AS $$
-BEGIN
- UPDATE
- posts
- SET
- updated_at = now()
- WHERE
- id = NEW.id;
- RETURN new;
-END;
-$$
-LANGUAGE plpgsql;
-
-CREATE TRIGGER janitor_trigger
- AFTER INSERT ON milla.tables
- EXECUTE PROCEDURE milla.janitor ();
-