Posted by dhek on 11/04/07 09:20

>> Well, my issue is that I'm reading data from tables A, B, C and D and
>> updates table E.
>>
>> What I need to prevent is 2 things:
>>
>> 1) New rows must not be added to either table A and B while my
>> transaction is executing
>> 2) Existing rows must not be modified
>
> Why?
>
> If that is truly the case, then yes, you need a table lock.
>
> But this seems like a fairly unusual requirement. Sure your design is
> really what you want?

With the current setup in the database I fear this is what I want (though
I'm not very keen on the idea either:-o). I'm just trying to investigate my
options for disallowing tables changes while my transaction is executing to
prevent "lost records" as mentioned in one of my other replies.

[Back to original message]