diff options
| author | terminaldweller <devi@terminaldweller.com> | 2024-06-15 13:43:57 +0000 |
|---|---|---|
| committer | terminaldweller <devi@terminaldweller.com> | 2024-06-15 13:43:57 +0000 |
| commit | 20f83572448187f806095ee0a8cc5b30bff72a93 (patch) | |
| tree | 4c36696a6629b8dc6615fc6e98a67872923ce86d /scripts/entry_limit_trigger.pgsql | |
| parent | added a shell.nix for pgformatter, and a wip trigger for db size maintenance (diff) | |
| download | milla-20f83572448187f806095ee0a8cc5b30bff72a93.tar.gz milla-20f83572448187f806095ee0a8cc5b30bff72a93.zip | |
added watchlists
Diffstat (limited to '')
| -rw-r--r-- | scripts/entry_limit_trigger.pgsql | 19 |
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 (); - |