On Wednesday 01 October 2003 16:24, OpenGis wrote:
> 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.
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.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
