From: Gavin_King/Cirrus%<CI...@ci...> - 2002-03-04 15:59:23
|
> What are the benefits in doing a "select for update" on the PK > after the data has been loaded? Why not just write the data and let > the database upgrade the lock automatically? woops. i misunderstood the sense of this question.... This would be of benefit for applications using longer-running transactions and also for applications using "long transactions with versioning", where you could use it to check the version number of an object you do not necessarily plan to update. |