X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 54EBF476332 for ; Tue, 15 Apr 2003 15:17:48 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 5CE58476332 for ; Tue, 15 Apr 2003 15:17:17 -0400 (EDT) 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 h3FJHHU6009422; Tue, 15 Apr 2003 15:17:17 -0400 (EDT) To: Robert Treat Cc: ow , pgsql-hackers@postgresql.org Subject: Re: Are we losing momentum? In-reply-to: <1050432610.9816.177.camel@camel> References: <20030415173019.49206.qmail@web21408.mail.yahoo.com> <1050432610.9816.177.camel@camel> Comments: In-reply-to Robert Treat message dated "15 Apr 2003 14:50:10 -0400" Date: Tue, 15 Apr 2003 15:17:17 -0400 Message-ID: <9421.1050434237@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-32.5 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/518 X-Sequence-Number: 38008 Robert Treat writes: > On Tue, 2003-04-15 at 13:30, ow wrote: >> One of the features that PostgreSql must have, IMHO, is support for >> cross-db operations (queries, updates, deletes, inserts). 2PC and >> cross-server stuff would be nice but it's not as important as simple >> cross -db operations across databases on the same server. All major >> comercial RDBMS (and even mySql!) support this but for Postgres. Sad. > dblink ? I'm of the opinion that the availability of schemas solves most of the problems that people say they need cross-database access for. If you want cross-database access, first say why putting your data into several schemas in a single database doesn't get the job done for you. (Obviously, this only addresses cases where you'd have put the multiple databases under one postmaster, but that's the scenario people seem to be concerned about.) regards, tom lane