Re: Request into several DBMS simultaneously on DDL and DML

From: Richard Huxton <dev(at)archonet(dot)com>
To: Kitter Georgiy <sql4-en(at)narod(dot)ru>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Request into several DBMS simultaneously on DDL and DML
Date: 2007-08-28 07:58:27
Message-ID: 46D3D5A3.6050503@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2007-08-28 07:59:38 Re: pg & Delphi
Previous Message Daniel Drotos 2007-08-28 06:54:29 Re: pg & Delphi