Re: Sinhronization of 2 transactions

Marko Dudi? wrote:

> I have 2 transactions. First collection of transactions starts before
> second and ends (commit) after the start of second transaction,
> therefor in second transaction i don't see the data from first
> transaction.
> How can i detect that first transaction is started or when its ends?
> I think that only solution is to detect start or end time of first
> transaction, and start second transaction in one of that times.
> But how to do that?
>
> marko

Sounds like trying to patch a very poorly designed application. But as you can not possibly know what another session is doing prior to a commit the only option is to create a semaphore or use a mechanism such as Advanced Queuing.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)