trigger.sql

// Deletes the image object in storage when the corresponding record is deleted

CREATE OR REPLACE FUNCTION delete_corresponding_image() RETURNS trigger AS
$$BEGIN
   DELETE 
   FROM storage.objects o
   LEFT JOIN public.images ON i.id = o.image_id
   RETURN NULL;
END;$$ LANGUAGE plpgsql;

CREATE TRIGGER delete_image_object_when_corresponding_record_is_deleted
   BEFORE DELETE ON public.images FOR EACH ROW
   EXECUTE PROCEDURE delete_corresponding_image();