X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 492364758F1 for ; Tue, 15 Apr 2003 21:00:11 -0400 (EDT) Received: from datafix.CS.Berkeley.EDU (datafix.CS.Berkeley.EDU [128.32.37.185]) by postgresql.org (Postfix) with ESMTP id 082F5475458 for ; Tue, 15 Apr 2003 21:00:06 -0400 (EDT) Received: (from sailesh@localhost) by datafix.CS.Berkeley.EDU (8.11.6/8.11.6) id h3G0oxf11088; Tue, 15 Apr 2003 17:50:59 -0700 X-Authentication-Warning: datafix.CS.Berkeley.EDU: sailesh set sender to sailesh@cs.berkeley.edu using -f Reply-To: sailesh@cs.berkeley.edu X-URL: http://www.cs.berkeley.edu/~sailesh X-Attribution: Sailesh To: Tom Lane Cc: bruc@acm.org, pgsql-hackers@postgresql.org Subject: Re: Are we losing momentum? References: <200304152254.h3FMsrwe047585@stone.congenomics.com> <10857.1050448704@sss.pgh.pa.us> From: Sailesh Krishnamurthy Date: 15 Apr 2003 17:50:59 -0700 In-Reply-To: <10857.1050448704@sss.pgh.pa.us> Message-ID: Lines: 28 User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.1 (Cuyahoga Valley) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Spam-Status: No, hits=-24.0 required=5.0 tests=BAYES_01,IN_REP_TO,REFERENCES,USER_AGENT_GNUS_UA, X_AUTH_WARNING 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/551 X-Sequence-Number: 38041 >>>>> "Tom" == Tom Lane writes: Tom> Please keep in mind that I was replying to a poster who said Tom> "cross-db queries on the same server (meaning same Tom> postmaster, for our purposes) are trivial; why hasn't Tom> Postgres got them when everybody else does?" BTW, DB2 doesn't have 'em either. In DB2, you have Database -> Schema -> Objects In DB2, you can of course have cross-schema queries but no cross-db queries, unless you rig up the federated functionality to connect one db to the other. Much of the confusion stems from SQL-Server and Sybase having: Database -> Objects The Database is used to identify distinct schemas. I'm not sure if in these systems they are physically separate entities (different lock manager etc.) -- Peace, at last ? Sailesh http://www.cs.berkeley.edu/~sailesh