Hal
07/31/2021, 3:19 AMHal
07/31/2021, 3:28 AMCREATE OR REPLACE FUNCTION public.update_updated_at()
RETURNS TRIGGER AS $$
BEGIN
NEW.updated_at = TIMEZONE('utc' :: TEXT, NOW());
RETURN NEW;
END;
$$ LANGUAGE plpgsql SECURITY DEFINER;
CREATE TRIGGER trigger_design_files_updated_at
BEFORE UPDATE ON public.design_files
FOR EACH ROW
EXECUTE PROCEDURE public.update_updated_at();
It works now! Failed because of forgetting to write public
I guess. Thanks.