From a927b30705d1e8c6b1b046e7512cc67cbdf19a21 Mon Sep 17 00:00:00 2001 From: Masaya Tojo Date: Wed, 13 Mar 2024 00:56:38 +0900 Subject: Remove update_updated_at functions. --- deploy/update_updated_at.sql | 15 --------------- 1 file changed, 15 deletions(-) delete mode 100644 deploy/update_updated_at.sql (limited to 'deploy/update_updated_at.sql') diff --git a/deploy/update_updated_at.sql b/deploy/update_updated_at.sql deleted file mode 100644 index a41d27f..0000000 --- a/deploy/update_updated_at.sql +++ /dev/null @@ -1,15 +0,0 @@ --- Deploy diary:update_updated_at to pg --- requires: schema - -BEGIN; - -SET search_path to diary; - -CREATE OR REPLACE FUNCTION update_updated_at() RETURNS TRIGGER AS $$ - BEGIN - NEW.updated_at = NOW(); - RETURN NEW; - END; -$$ LANGUAGE plpgsql; - -COMMIT; -- cgit v1.2.3