Re: [NOVICE] idiom for interactive client applications.

From: Richard Broersma Jr <rabroersma(at)yahoo.com>
Date: Fri Oct 12 2007 - 23:49:00 EDT

• 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.

---------------------------(end of broadcast)---------------------------

TIP 7: You can help support the PostgreSQL project by donating at

                
http://www.postgresql.org/about/donate

Received on Fri Oct 12 23:51:56 2007