Changes between Version 33 and Version 34 of DatabaseProgramming

Timestamp:

06/16/26 02:27:24 (26 hours ago)

Author:

231119

Comment:

--

DatabaseProgramming

@@ -799 +799 @@
     if OLD.status = 'pending' and NEW.status = 'accepted' then
       if (NOW() - OLD.created_at) > interval '5 minutes' then
-            NEW.status := 'expired';
+            NEW.status := 'cancelled';
             raise notice 'Offer % has expired and cannot be accepted.', OLD.id;
             return NEW;