Best practice updating data in webapps? - Mailing list pgsql-general

From Bjørn T Johansen
Subject Best practice updating data in webapps?
Date
Msg-id 41A469CE.7050109@havleik.no
Whole thread Raw
List pgsql-general
Maybe a bit outside the scope of PGSQL but when designing webapps where different users
can edit the same record at the same time, what is the best way to solve this situation?
One way is to use an update field, that gets selected with rest of the data and when
updating the data, check this update field with the one in the db; if they don't match,
someone else has updated the record before you..
But is this the best way?


Regards,

BTJ

--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen

btj@havleik.no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------

pgsql-general by date:

Previous
From: "Najib Abi Fadel"
Date:
Subject: Re: Row creation time
Next
From: "songsubo"
Date:
Subject: Insert may fail if i create a primary key on the oid column?