From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Joe Conway <mail(at)joeconway(dot)com> |
Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, ted(at)3shmoos(dot)ca, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Live Link to Oracle? |
Date: | 2003-04-15 03:53:28 |
Message-ID: | 200304150353.h3F3rSu09901@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Joe Conway wrote:
> Martijn van Oosterhout wrote:
> > On Tue, Apr 08, 2003 at 08:37:16AM -0400, Ted Taylor wrote:
> >
> >>I'd like to set up a pgsql database that has server-based links back to
> >>an Oracle db. Not replication, but a live link (the data I'm looking
> >>for can change rapidly). The pgsql client would see it as a native
> >>pgsql table, but the pgsql server would submit the query to Oracle in
> >>real-time. Basically, a view of the Oracle data.
> >
> > There is a dblink in in the postgres source that does this between seperate
> > postgres servers. Perhaps just altering this to deal if oracle servers
> > instead would be possible?
>
> Someone has already modified dblink to use JDBC successfully. He sent me
> the code, but did not announce anything because he really didn't have
> time to support it.
>
> I'm hoping to have enough time to integrate the jdbclink code into
> dblink before the freeze for 7.4, but no promises.
Wow, I can see that having amazing possibilities, which dblink has lots
of already!
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Hoffmann | 2003-04-15 03:54:11 | Re: Are we losing momentum? |
Previous Message | Bruce Momjian | 2003-04-15 03:45:29 | Re: CVS doesn't compile initdb and other binaries |