Re: [HACKERS] PostgreSQL Backend as SW Gateway to Oracle - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] PostgreSQL Backend as SW Gateway to Oracle
Date
Msg-id 35A4C3D7.E9299AD7@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] PostgreSQL Backend as SW Gateway to Oracle  (Armin Schloesser <armin@ap-kas.ie.philips.com>)
Responses Re: [HACKERS] PostgreSQL Backend as SW Gateway to Oracle
Re: [HACKERS] PostgreSQL Backend as SW Gateway to Oracle
List pgsql-hackers
> Nevertheless I would like to implement this Oracle Gateway using the
> PostgeSQL stuff.
> Cause using the Oracle OCI there has to be some preprocessing done to
> parse the libpq SQL strings for binding input and output variables to.
> So a simple SELECT call is not mappable to a single OCI call.
> If there are also other guys outside interested in this approach, it
> would be perhaps worth to discuss also their requirements to get a
> proper functional spec to implement the SW gateway.

I don't have a particular interest in the Oracle gw, but am interested
in getting simultaneous multiple db access within Postgres. I had been
thinking of trying to implement this as a Postgres "master database"
with hooks deeper in the backend to call out to a remote database as a
separate session. Sort of like Ingres implemented their distributed
databases. Haven't done anything with it though...

                       - Tom

pgsql-hackers by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: [HACKERS] Some items for the TODO list
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [INTERFACES] Re: [HACKERS] Access & Postgres