From: | "Ted Taylor" <ted(at)3shmoos(dot)ca> |
---|---|
To: | "'Martijn van Oosterhout'" <kleptog(at)svana(dot)org> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Live Link to Oracle? |
Date: | 2003-04-09 09:58:36 |
Message-ID: | 000e01c2fe7e$97320f90$0201a8c0@ted |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Martijn. Although I consider myself a programmer, I do not
consider myself talented enough to modify the source of pgsql. I guess
I'm looking for a "canned solution".
Ted.
-----Original Message-----
From: Martijn van Oosterhout [mailto:kleptog(at)svana(dot)org]
Sent: April 8, 2003 7:35 PM
To: ted(at)3shmoos(dot)ca
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Live Link to Oracle?
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?
Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values
> or religion but rather by its superiority in applying organized
> violence. Westerners often forget this fact, non-Westerners never do."
> - Samuel P. Huntington
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua Moore-Oliva | 2003-04-09 10:39:11 | aaagh... postgres is segfaulting? |
Previous Message | Manoj Patwardhan | 2003-04-09 09:34:58 | Re: Question on initdb and subsequent start |