From: | Szymon Guz <mabewlun(at)gmail(dot)com> |
---|---|
To: | Robert Sosinski <rsosinski(at)ticketevolution(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Time-based trigger |
Date: | 2012-09-18 16:03:22 |
Message-ID: | CAFjNrYvKLpO5Dnx11O+2aJt4ifQOjT1VdjGtRMDsXJVEescU-g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 18 September 2012 17:59, Robert Sosinski
<rsosinski(at)ticketevolution(dot)com>wrote:
> 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
>
>
It is not possible right now, however I'd rather create some cron job which
updates the boolean value if needed and runs each minute.
- Szymon
From | Date | Subject | |
---|---|---|---|
Next Message | Yvon Thoraval | 2012-09-18 16:08:25 | Re: On Ubuntu 12.04 i do have two psql one of those isn't working |
Previous Message | Robert Sosinski | 2012-09-18 15:59:35 | Time-based trigger |