| From: | Robert Sosinski <rsosinski(at)ticketevolution(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Time-based trigger |
| Date: | 2012-09-18 15:59:35 |
| Message-ID: | 689D39ED76CF4967B823E2718CF15A82@ticketevolution.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
We have a table, which has items that can be put on hold of 5 minutes (this is for an online store) once they are placed into a cart. What we need is for this hold to automatically expire after 5 minutes. Right now, we put a time stamp into the row (called hold_until) at 5 minutes into the future, and select items where hold_until is less then now().
Would it be possible to change this to using a boolean that is set to true when item is put on hold, and have something like a time-based trigger automatically update the held boolean to false after 5 minutes pass.
Thanks,
--
Robert Sosinski
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Szymon Guz | 2012-09-18 16:03:22 | Re: Time-based trigger |
| Previous Message | Raymond O'Donnell | 2012-09-18 15:51:24 | Re: On Ubuntu 12.04 i do have two psql one of those isn't working |