Re: Live Link to Oracle?

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@svana.org]
Sent: April 8, 2003 7:35 PM
To: ted@3shmoos.ca
Cc: pgsql-general@postgresql.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@svana.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