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