Re: Are we losing momentum?

Sailesh Krishnamurthy <sailesh@cs.berkeley.edu>

From: Sailesh Krishnamurthy <sailesh@cs.berkeley.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: bruc@acm.org, pgsql-hackers@postgresql.org
Date: 2003-04-16T00:50:59Z
Lists: pgsql-hackers
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> 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