Subject Re: [firebird-support] Avoiding pessimistic locking
Author Dmitry Sibiryakov
On 7 Oct 2005 at 8:09, Kjell Rilbe wrote:

>Dmitry Sibiryakov wrote:
>> Actually, the problem is a matter of authority. Why all A, B and C
>> are allowed to edit the same record? Who has "more right"
>> information?
>A is updating the order record because she got a notification that the
>goods has been delivered while B is updating it because he's just
>mailed the invoice, and C is updating it because the customer just
>called to say that she will be returning one of the items because it
>was damaged?

It smells like denormalized DB structure.
Can't say about delivery confirmation, but history of sent invoices
and accepted reclamations I'd put into separate tables...

SY, Dimitry Sibiryakov.