Waiting on a transaction - Mailing list pgsql-general

From Bill Moseley
Subject Waiting on a transaction
Date
Msg-id 20050816180535.GA8845@hank.org
Whole thread Raw
Responses Re: Waiting on a transaction  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
I've read over the docs on Concurrency Control but still not clear
about when transactions block other updates, and how to deal with that
on the application level.

If I do a BEGIN and an UPDATE in one psql session and then try and do
an UPDATE in another psql session that UPDATE waits until either a
COMMIT or ROLLBACK.

Is it common for applications using Postgresql to set a timer on
updates and abort?


--
Bill Moseley
moseley@hank.org


pgsql-general by date:

Previous
From: marcelo Cortez
Date:
Subject: Re: lock problem
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Waiting on a transaction