Re: [HACKERS] PostgreSQL Backend as SW Gateway to Oracle

On Thu, 9 Jul 1998, Thomas G. Lockhart wrote:

> > 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...

Cewl... wouldn't this enable us to run PostgreSQL on beowolf-like
clusters? :) (for those of you unknown to them, see
http://cesdis.gsfc.nasa.gov/beowulf/consortium/consortium.html, this one
is also very nice :) http://cnls.lanl.gov/avalon/ ).

Maarten

_____________________________________________________________________________
| TU Delft, The Netherlands, Faculty of Information Technology and Systems |
| Department of Electrical Engineering |
| Computer Architecture and Digital Technique section |
| M(dot)Boekhold(at)et(dot)tudelft(dot)nl |
-----------------------------------------------------------------------------