Re: [GENERAL] One SQL to access two databases. - Mailing list pgsql-hackers

From Joe Conway
Subject Re: [GENERAL] One SQL to access two databases.
Date
Msg-id 3DEB90C9.5010808@joeconway.com
Whole thread Raw
In response to Re: [GENERAL] One SQL to access two databases.  (Karel Zak <zakkr@zf.jcu.cz>)
Responses Re: [GENERAL] One SQL to access two databases.  (Karel Zak <zakkr@zf.jcu.cz>)
List 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



pgsql-hackers by date:

Previous
From: Lee Kindness
Date:
Subject: Re: 7.3 gotchas for applications and client libraries
Next
From: Nicolai Tufar
Date:
Subject: Patch to make Turks happy.