--- 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.
Richard Broersma Jr.
In response to
pgsql-novice by date
|Next:||From: Syan Tan||Date: 2007-10-13 04:28:13|
|Subject: Re: idiom for interactive client applications.|
|Previous:||From: syan tan||Date: 2007-10-13 02:14:21|
|Subject: idiom for interactive client applications.|