[SQL] Link Oracle tables in Postgre

[OpenGis]

Howdy,

I’d like to do (live) link of Oracle table (on win) in Postgres (on RH9 
box).
In Oracle are stored attribute of my spatial layer collect in 
postgres-postgis geo-database ono-to-one relationship. I use Mapserver 
(http://mapserver.gis.umn.edu) in order to render web map stored in 
postgres. I need to perform filer after do JOIN between oracle-postgres 
data.

Any suggest?

Do you know where can I find documentation? best-practice?
Thank
--
opengis (at) libero (dot) it


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] Link Oracle tables in Postgre

[OpenGis]

Josh Berkus wrote:

  Richard,

  
  
You might want to search the mailing list archives for discussion of an
oracle version of dblink - I seem to remember someone saying they were
working on such a thing.

  
  
Yes, it'll be out sometime after 7.4.   According to their posts in August, 
it's in alpha right now and just barely didn't make it into the 7.4 source.

  

It's right!!

at the end, I install everything!

In order to install Oracle9 on RH9 (not supported linux version) it's
necessary to set LD_ASSUME_KERNEL = 2.4.1

Al last I've install OCI (full Oracle client runtime) -> libsqlora8
-> dblink_ora (developed by Hans Jurgen Schonig).


Best regards

-- 
opengis (at) libero (dot) it
AOL: open2gis