Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 16AF19FA1E3 for ; Tue, 28 Aug 2007 05:09:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 99205-04 for ; Tue, 28 Aug 2007 05:09:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id E19029FA186 for ; Tue, 28 Aug 2007 05:09:10 -0300 (ADT) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id A5D421450AB; Tue, 28 Aug 2007 08:58:27 +0100 (BST) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 61246274057; Tue, 28 Aug 2007 08:58:27 +0100 (BST) Message-ID: <46D3D5A3.6050503@archonet.com> Date: Tue, 28 Aug 2007 08:58:27 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 To: Kitter Georgiy Cc: pgsql-sql@postgresql.org Subject: Re: Request into several DBMS simultaneously on DDL and DML References: <195471188276289@webmail10.yandex.ru> In-Reply-To: <195471188276289@webmail10.yandex.ru> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/231 X-Sequence-Number: 29169 Kitter Georgiy wrote: > (1)Let's allow to __connect into several DBMS__ at once, > last of them becomes DBMS 'by default'. ... > It's necessary to not signalize about break of foreign key, > if remote database will not connected in next time. But that's the vital bit. Without being able to extend relational integrity checks across database boundaries you're not really getting something that's general-use. Without that it's not really worth extending syntax - dblink() offers a solution to the limited cases available. If you manage to come up with an efficient multi-master replication system though, please let us know :-) -- Richard Huxton Archonet Ltd