Re: Re: [GENERAL] Queries across multiple databases ?(was: SELECT from a table in another database).

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Zak McGregor <zak(at)mighty(dot)co(dot)za>, Andrew Rawnsley <ronz(at)ravensfield(dot)com>, pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Re: [GENERAL] Queries across multiple databases ?(was: SELECT from a table in another database).
Date: 2001-05-22 11:31:18
Message-ID: 200105221131.f4MBVIc28574@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> > I'm not sure whether it is quite the way to do it, but I'd have a better
> > time with things if I could span databases in a single request. Are
> > there theoretical problems with spanning databases in a single query? Is
> > it a feature of bad database design & implementation?
>
> I think the developers are planning full schema support for the relatively
> near future (possibly even 7.2, but check the archives and see what's been
> said). Although it looks easy to access a table from another database,
> things can rapidly become more complicated as you start having to deal with
> transactions, triggers, rules, constraints...

Schema is on my radar screen for 7.2. I am waiting to do some research
in what needs to be done, but my initial idea is to use the system cache
to do namespace mapping, just like is done now for temp tables.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2001-05-22 11:42:49 Unexpected query plan
Previous Message Ludovico Romano 2001-05-22 10:30:32 how to convert Access to PG unless odbc driver(with sql file)

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-05-22 11:34:14 Re: Is stats update during COPY IN really a good idea?
Previous Message Bruce Momjian 2001-05-22 11:23:45 Re: shared library strangeness?