Skip site navigation (1) Skip section navigation (2)

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

From: Armin Schloesser <armin(at)ap-kas(dot)ie(dot)philips(dot)com>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] PostgreSQL Backend as SW Gateway to Oracle
Date: 1998-07-09 06:13:48
Message-ID: Pine.LNX.3.95.980709080212.11050A-100000@papkas (view raw or flat)
Thread:
Lists: pgsql-hackers
Hello Bruce,

thanks for your reply.

I already have anticipated that there is no off the shelf solution for my
problem.

A wrapper linpq I dont't want to use, cause then I would have to link
against different stuff coneccting to PostgreSQL and Oracle. I want to
have this switching done not in my application, but in a separate process.

After all the Oracle client SW is not available under Linux.

Nevertheless I would like to implement this Oracle Gateway using the
PostgeSQL stuff.

Now the problem for me is how to get used to the backend architecture as
fast as possible. That means is there any more deeper technical doku
available, describing the backend control flow and architekture.
Especially the layout of list and nodes structure of the parser.

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.  

Sorry for the long lines. I used the netscape to generate the mail and he
doen't complain about long lines. I will use the good old pine in the
future.

Greetings,

Dr. Armin. Schloesse

==============================================================================
Philips Automation Projects               Phone:  +49 561 501 1395
Miramstr. 87                              Fax:    +49 561 501 1688
34123 Kassel                              Email:  armin(at)ap-kas(dot)ie(dot)philips(dot)com
Germany      
==============================================================================

On Wed, 8 Jul 1998, Bruce Momjian wrote:

> (still using the libpg). >  > Now after this lengthy introduction my
> questions: >  > 1 Could you give me more information on how and where to
> hook into the backend code to implement this >  >   stuff. >  > 2 Is
> there anyone outside that will be interested also in this approach. >  >
> 3 Are you interested in getting back the new stuff >  > Thanks a lot for
> your patience!! >  > Greetings, >  > Dr. Armin. Schloesser >  >
> 
> [See what happens when you send lines >80.]
> 
> You want to use libpq to send that through the backend, and then pass it
> to Oracle.  Some people have asked for this, but I know of know way to
> accomplish this.  Your best be would be to create a fake libpq, that has
> the same function names/behavior, but calls native Oracle C functions.
> 
> 
> -- 
> Bruce Momjian                          |  830 Blythe Avenue
> maillist(at)candle(dot)pha(dot)pa(dot)us              |  Drexel Hill, Pennsylvania 19026
>   +  If your life is a hard drive,     |  (610) 353-9879(w)
>   +  Christ can be your backup.        |  (610) 853-3000(h)
> 


In response to

Responses

pgsql-hackers by date

Next:From: David GouldDate: 1998-07-09 07:07:37
Subject: Re: [HACKERS] New s_lock.h fails on HPUX with gcc
Previous:From: Thomas G. LockhartDate: 1998-07-09 05:44:58
Subject: Recent updates

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group