Re: Live Link to Oracle?
От | Ted Taylor |
---|---|
Тема | Re: Live Link to Oracle? |
Дата | |
Msg-id | 000e01c2fe7e$97320f90$0201a8c0@ted обсуждение исходный текст |
Ответ на | Re: Live Link to Oracle? (Martijn van Oosterhout <kleptog@svana.org>) |
Список | 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@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
В списке pgsql-general по дате отправления: