Re: Request into several DBMS simultaneously on DDL and DML - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Request into several DBMS simultaneously on DDL and DML
Date
Msg-id 46D3D5A3.6050503@archonet.com
Whole thread Raw
In response to Request into several DBMS simultaneously on DDL and DML  (Kitter Georgiy <sql4-en@narod.ru>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Daniel Drotos
Date:
Subject: Re: pg & Delphi
Next
From: Richard Huxton
Date:
Subject: Re: pg & Delphi