Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 28 Aug 2007 08:58:27 +0100
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
- References:
- Request into several DBMS simultaneously on DDL and DML
- From: Kitter Georgiy
- Request into several DBMS simultaneously on DDL and DML
- Prev by Date: Re: pg & Delphi
- Next by Date: Re: pg & Delphi
- Previous by thread: Request into several DBMS simultaneously on DDL and DML
- Next by thread: pg & Delphi
- Indexes: