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

From Bruce Momjian
Subject Re: [GENERAL] Re: [GENERAL] Queries across multiple databases ?(was: SELECT from a table in another database).
Date
Msg-id 200105221131.f4MBVIc28574@candle.pha.pa.us
Whole thread Raw
List 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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: shared library strangeness?
Next
From: Bruce Momjian
Date:
Subject: Re: Is stats update during COPY IN really a good idea?