| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
| 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-02 16:56:41 |
| Message-ID: | 3DEB90C9.5010808@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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.
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.
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-12-02 17:50:03 | protecting prosrc (was Re: USAGE on schema allowed by default?) |
| Previous Message | Raymond Chui | 2002-12-02 16:41:33 | CURRENT_TIMSTAMP |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicolai Tufar | 2002-12-02 16:58:38 | Patch to make Turks happy. |
| Previous Message | Lee Kindness | 2002-12-02 16:30:15 | Re: 7.3 gotchas for applications and client libraries |