Thats a good idea! I can see how updating the existing record
(marking 'free space') and turning it into a 'real' record would
pesimistically block someone else from updating it too.

But what about editing an existing 'real' record?

--- In firebird-support@yahoogroups.com, Lester Caine <lester@l...>
wrote:

> All time segments are in the database - even the gaps. Select the

one

> you want to insert into, and write back the one, two or three

segments

> that are created. Which ever gets in first will win, and the

second

> attempt can be retried against the new free space. The start and

stop

> times of the free space are then automatically flagged, and you

could

> flag the free space with the user_id of the person who accessed it

first?