From: Sailesh Krishnamurthy <sailesh@cs.berkeley.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: bruc@acm.org
Cc: pgsql-hackers@postgresql.org
Subject: Re: Are we losing momentum?
Date: 15 Apr 2003 17:50:59 -0700
Message-ID: <bxywuhv2rkc.fsf@datafix.CS.Berkeley.EDU> (raw)
In-Reply-To: <10857.1050448704@sss.pgh.pa.us>
References: <200304152254.h3FMsrwe047585@stone.congenomics.com>
<10857.1050448704@sss.pgh.pa.us>
>>>>> "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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: sailesh@cs.berkeley.edu, tgl@sss.pgh.pa.us, bruc@acm.org
Subject: Re: Are we losing momentum?
In-Reply-To: <bxywuhv2rkc.fsf@datafix.CS.Berkeley.EDU>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox