blocking with time out?

From: "Kent Tong" <kent(at)cpttm(dot)org(dot)mo>
To: pgsql-general(at)postgresql(dot)org
Subject: blocking with time out?
Date: 2000-02-04 02:27:51
Message-ID: 200002040228.VAA89272@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am experimenting with the serializable isolation level. If two
such transactions try to execute an UPDATE on the same record in
tandem, then the latter will be blocked forever until the former
rolls back or commits.

Is there any way to set a time out so that the latter will return
an error earlier? The rationale is that, if two users are trying
to edit the same record, then one of them will be kept waiting until
the other user OKs or cancels his own edit dialog. For the unforunate
user, the app will appear to have freezed. This creates a very bad
experience on the user.

Any idea to get this time out effect?

Thanks in advance!
--
Kent Tong, M.Sc., MCSE, MCP+I
FREE advice to enhance your business with IT
FREE catalogue of IT products in the Macau market
Go to http://www.cpttm.org.mo/itob NOW!

Browse pgsql-general by date

  From Date Subject
Next Message Kent Tong 2000-02-04 03:13:36 time out in blocking
Previous Message Ross J. Reedstrom 2000-02-04 00:28:47 Re: [HACKERS] Re: [SQL] Proposed Changes to PostgreSQL