RE: Re: SELECT FOR UPDATE

From: "Andrew Snow" <andrew(at)modulus(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: RE: Re: SELECT FOR UPDATE
Date: 2001-08-23 13:49:52
Message-ID: 000001c12bda$7c30ea90$fa01b5ca@avon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I prefer the way Notes (for example) handles it. All
records/documents/views are in read-only mode until the user indicates
they actually want to edit. They then exclusively lock that record for
editing, with optional timeouts (in case their workstation crashes or
whatever).

This turns out to work well in many situations where you realise the
number of times you want to edit compared to the number of times you
want to view, is quite small. Stops users having to worry whether
anyone else is editing the record at the same time - the system simply
won't let them - no loss of data.

Andrew

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message wsheldah 2001-08-23 13:50:31 How do I drop or change a foreign key?
Previous Message Eric, Audet 2001-08-23 13:43:40 Postgres and special character