From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
---|---|
To: | Pgsql-General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: "Expiring" transactions? |
Date: | 2003-09-24 02:10:50 |
Message-ID: | 3F70FD2A.1070008@paradise.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Most web appl servers have settings to do this for you, or APIs you can
use.
e.g. for J2EE see SessionBindingListener
regards
mark
Egor Shipovalov wrote:
>Is there a way to make transaction automatically COMMIT or ROLLBACK after
>certain period of time?
>I want website visitors to be able to page through search results using
>single cursor. Since users can leave the site at any time, I can't know when
>to end their transaction.
>
>I guess I can write a broker that gives each user a connection and tracks
>when he's gone, performing necessaty cleanup, but isn't there a simplier
>way?
>
>Best regards,
>Egor Shipovalov.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Shraibman | 2003-09-24 02:15:30 | how smart is is pg with shared_buffers? |
Previous Message | Egor Shipovalov | 2003-09-24 01:53:49 | "Expiring" transactions? |