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 27798D1B50E for ; Wed, 1 Oct 2003 15:25:55 +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 56466-08 for ; Wed, 1 Oct 2003 12:25:06 -0300 (ADT) Received: from server-exchange.edinform.it (unknown [213.82.241.131]) by svr1.postgresql.org (Postfix) with ESMTP id 04EA8D1B510 for ; Wed, 1 Oct 2003 12:24:23 -0300 (ADT) Received: from libero.it ([192.1.2.47]) by server-exchange.edinform.it with Microsoft SMTPSVC(5.0.2195.5329); Wed, 1 Oct 2003 17:24:13 +0200 Message-ID: <3F7AF19D.1000902@libero.it> Date: Wed, 01 Oct 2003 17:24:13 +0200 From: OpenGis User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Link Oracle tables in Postgre Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-OriginalArrivalTime: 01 Oct 2003 15:24:13.0280 (UTC) FILETIME=[11AC0600:01C38830] X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=USER_AGENT_MOZILLA_UA X-Spam-Level: X-Archive-Number: 200310/10 X-Sequence-Number: 15410 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