X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id BB026D1B510
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  1 Oct 2003 15:44:29 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 59367-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  1 Oct 2003 12:43:43 -0300 (ADT)
Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net
	[194.217.242.89])
	by svr1.postgresql.org (Postfix) with ESMTP id E37CAD1B543
	for <pgsql-sql@postgresql.org>; Wed,  1 Oct 2003 12:43:42 -0300 (ADT)
Received: from mwynhau.demon.co.uk ([193.237.186.96]
 helo=mainbox.archonet.com)
	by anchor-post-31.mail.demon.net with esmtp (Exim 3.35 #1)
	id 1A4j8g-0001If-0V; Wed, 01 Oct 2003 16:43:42 +0100
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mainbox.archonet.com (Postfix) with ESMTP
	id 4FA691632E; Wed,  1 Oct 2003 16:43:41 +0100 (BST)
Received: from client17.archonet.com (client17.archonet.com [192.168.1.17])
	by mainbox.archonet.com (Postfix) with ESMTP
	id 83382162EE; Wed,  1 Oct 2003 16:43:40 +0100 (BST)
From: Richard Huxton <dev@archonet.com>
To: OpenGis <opengis@libero.it>, pgsql-sql@postgresql.org
Subject: Re: Link Oracle tables in Postgre
Date: Wed, 1 Oct 2003 16:43:39 +0100
User-Agent: KMail/1.5
References: <3F7AF19D.1000902@libero.it>
In-Reply-To: <3F7AF19D.1000902@libero.it>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="windows-1252"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200310011643.39500.dev@archonet.com>
X-Virus-Scanned: by AMaViS snapshot-20020531
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200310/12
X-Sequence-Number: 15412

On Wednesday 01 October 2003 16:24, OpenGis wrote:
> Howdy,
>
> I=92d 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 ora=
cle=20
version of dblink - I seem to remember someone saying they were working on=
=20
such a thing.


--=20
  Richard Huxton
  Archonet Ltd