X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8694ED1B915 for ; Wed, 27 Aug 2003 00:37:45 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 51036-10 for ; Wed, 27 Aug 2003 00:37:34 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 3F472D1B8B9 for ; Wed, 27 Aug 2003 00:37:34 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h7R3bB5H006359; Tue, 26 Aug 2003 23:37:11 -0400 (EDT) To: Bruce Momjian Cc: Jan Wieck , Chris Travers , Alvaro Herrera , Ron Johnson , PostgreSQL-development Subject: Re: [GENERAL] Replication Ideas In-reply-to: <200308270325.h7R3PfI24921@candle.pha.pa.us> References: <200308270325.h7R3PfI24921@candle.pha.pa.us> Comments: In-reply-to Bruce Momjian message dated "Tue, 26 Aug 2003 23:25:41 -0400" Date: Tue, 26 Aug 2003 23:37:10 -0400 Message-ID: <6358.1061955430@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/1087 X-Sequence-Number: 42744 Bruce Momjian 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