Re: Simulating serial fields: locking a row with select for update

> We need to simulate the functionality of serial fields, because for > various reasons we cannot use them. > > We have a field in a table that contains the number to be incremented - > the serial (in fact we have a row in that table for each serial to be > implemented) and we need to lock the row while the number is readed and > updated. > > We thought to do it using 'select for update' but it seems not to work > because other users can read the old value after the 'select for update' > statement and before the commit. First lock row: update serial_generator set any_colon = any_colon where row_id = ... Regards, Mirko Marovic e-mail: mmarovic@eunet.yu