Re: [GENERAL] One SQL to access two databases.

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr>, hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] One SQL to access two databases.
Date: 2002-12-03 09:13:21
Message-ID: 20021203091321.GA12458@zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


On Mon, Dec 02, 2002 at 08:56:41AM -0800, Joe Conway wrote:
> Karel Zak wrote:
> >On Sat, Nov 30, 2002 at 01:11:20PM -0800, Joe Conway wrote:
> >
> >>As I said, this is all very preliminary; comments, suggestions, requests
> >>are all welcome.
> >
> > Only idea/dream: what implement dblink as "virtual" schema.
> >
> > CREATE SCHEMA myschema AS DBLINK TO ... some connection options ...;
> >
> > SELECT * FROM myschema.tabname;
> >
> > This solution allows use dblink as really transparent.
>
> Yeah, something along these lines is in my long term vision, but I don't
> think it will happen for 7.4. I'd like one more contrib/dblink release for
> the code to mature, and to solidify the features and understand the common
> usage issues.

Agree. This expect load a lot of information about remote tables to BE for
correct planner & executor running. BTW, do you think is possible load
this information also from non-PostgreSQL servers (Oracle, DB2...)?

The problem with multiple client-SQL libs in BE is only a small part of
transparent DBLINK imlementetion.

> Hopefully for the release *after* 7.4 I'll be ready to make a proposal to
> integrate dblink into the backend, get it accepted, and get it implemented.

If you want to (a lot) use client library in backend it will need real and
better memory managemnt for FE libs -- for example same mmgr as use BE.

Karel

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Björklund 2002-12-03 09:20:23 Re: 7.4 Wishlist
Previous Message Harry Yau 2002-12-03 09:13:09 Problem of Null Ordering

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2002-12-03 09:19:39 Re: Shrinkwrap Windows Product, any issues? Anyone?
Previous Message Tom Lane 2002-12-03 06:57:59 Re: 7.4 Wishlist