Thread: Re: [GENERAL] Replication Ideas

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> If you can detect if outside transactions conflict with your
> transaction, you should be able to determine if the outside transactions
> conflict with each other.

Uh ... not necessarily.  That amounts to assuming that every xact has
complete knowledge of the actions of every other, which is an assumption
I'd rather not make.  Detecting that what you've done conflicts with
someone else is one thing, detecting that party B has conflicted with
party C is another league entirely.
        regards, tom lane

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > If you can detect if outside transactions conflict with your
> > transaction, you should be able to determine if the outside transactions
> > conflict with each other.
> 
> Uh ... not necessarily.  That amounts to assuming that every xact has
> complete knowledge of the actions of every other, which is an assumption
> I'd rather not make.  Detecting that what you've done conflicts with
> someone else is one thing, detecting that party B has conflicted with
> party C is another league entirely.

Yep.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073