--- syan tan <kittylitter(at)people(dot)net(dot)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.