Re: idiom for interactive client applications.

--- syan tan <kittylitter@people.net.au> wrote:
> What other ways are there of doing such an app?

The two ways that I know of are:

BEGIN TRANSACTION ISOLATION LEVEL SERIALIZABLE;

--if the tuple was modified by another transaction, this transaction will fail on commit.

SELECT FOR UPDATE... -- pre-lock the tuple of interest from other commits.

Regards,
Richard Broersma Jr.