pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedLink Oracle tables in Postgre
4+ messages / 3 participants
[nested] [flat]
* Link Oracle tables in Postgre
@ 2003-10-01 15:24 OpenGis <opengis@libero.it>
0 siblings, 1 reply; 4+ messages in thread
From: OpenGis @ 2003-10-01 15:24 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Link Oracle tables in Postgre
@ 2003-10-01 15:43 Richard Huxton <dev@archonet.com>
parent: OpenGis <opengis@libero.it>
0 siblings, 1 reply; 4+ messages in thread
From: Richard Huxton @ 2003-10-01 15:43 UTC (permalink / raw)
To: OpenGis <opengis@libero.it>; pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Link Oracle tables in Postgre
@ 2003-10-01 16:59 Josh Berkus <josh@agliodbs.com>
parent: Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 4+ messages in thread
From: Josh Berkus @ 2003-10-01 16:59 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; OpenGis <opengis@libero.it>; pgsql-sql
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.
--
Josh Berkus
Aglio Database Solutions
San Francisco
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Link Oracle tables in Postgre
@ 2003-10-29 15:03 OpenGis <opengis@libero.it>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 4+ messages in thread
From: OpenGis @ 2003-10-29 15:03 UTC (permalink / raw)
To: ; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-10-29 15:03 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-10-01 15:24 Link Oracle tables in Postgre OpenGis <opengis@libero.it>
2003-10-01 15:43 ` Richard Huxton <dev@archonet.com>
2003-10-01 16:59 ` Josh Berkus <josh@agliodbs.com>
2003-10-29 15:03 ` OpenGis <opengis@libero.it>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox