|
Hi all
I have been reading up on 'optimistic concurrency
control'.
The following quote is taken from the on-line help
for MS SQL Server 2000 -
"Optimistic concurrency control works on the
assumption that resource conflicts between multiple users are unlikely (but not
impossible), and allows transactions to execute without locking any resources.
Only when attempting to change data are resources checked to determine if any
conflicts have occurred. If a conflict occurs, the application must read the
data and attempt the change again."
MS SQL Server uses a 'timestamp' column to check if
a row has been altered since it was read. The equivalent in PostgreSQL seems to
be the system column 'xmin'. However, the notes say 'You do not really need to
be concerned about these columns, just know they exist.' Is it ok to use xmin
for this purpose, or is there another way of achieving OCC?
TIA
Frank Millman
|
