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

2002-12-03 Thread Karel Zak
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.

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

2002-12-02 Thread Shridhar Daithankar
On 2 Dec 2002 at 12:05, 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 ...

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

2002-12-02 Thread Karel Zak
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 *

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

2002-12-02 Thread Joe Conway
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

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

2002-11-30 Thread Darko Prenosil
On Friday 29 November 2002 17:14, Joe Conway wrote: [EMAIL PROTECTED] wrote: Does anybody know if postgres support a SQL statement that handles two diferent databases (in the same server)? Have a look at the contrib/dblink directory in the standard postgresql distro. Didnt find such a

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

2002-11-30 Thread Joe Conway
Darko Prenosil wrote: Now when the 7.3 release is out,can we get back to plpq ? I did send You sources before vacation, and You said that You will take a look. I hope I am not disturbing You. If You think that this is bad Idea, I give up hope that we merge this functions into dblink, an I