> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
> Sent: Tuesday, April 15, 2003 12:35 PM
> To: Dann Corbit
> Cc: Robert Treat; ow; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Are we losing momentum? 
> 
> 
> "Dann Corbit" <DCorbit@connx.com> writes:
> >> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> >> I'm of the opinion that the availability of schemas solves 
> >> most of the problems that people say they need cross-database 
> >> access for.  If you want cross-database access, first say why 
> >> putting your data into several schemas in a single database 
> >> doesn't get the job done for you.
> 
> > Because you had to buy several packages to solve your problems.
> 
> And?
> 
> ISTM you can put 'em in the same database anyway.

Sure you can.  It's not easy of course.  That's one of the things that
CONNX software does (I work for CONNX Solutions Inc.).  Certainly, the
PostgreSQL group could accomplish the same thing, if they put their mind
to it.

I can easily join PostgreSQL tables to Oracle tables and insert the
result set into DB/2.  No programs, no extracts.  Just a SQL query.


Tue, 15 Apr 2003 12:39:52 -0700
"Dann Corbit" <DCorbit@connx.com>
Re: Are we losing momentum? 

Dann wrote:
>Sure you can.  It's not easy of course.  That's one of the things that
>CONNX software does (I work for CONNX Solutions Inc.).  Certainly, the
>PostgreSQL group could accomplish the same thing, if they put their mind
>to it.
>
>I can easily join PostgreSQL tables to Oracle tables and insert the
>result set into DB/2.  No programs, no extracts.  Just a SQL query.

Very interesting...  I was just in a conversation here at work about
joining data from an oracle system with data in a postgresql 
system...



FWIW, Oracle has something called "Oracle Generic Connectivity" 
and "Oracle Transparent Gateways" that do similar.

http://otn.oracle.com/products/oracle9i/datasheets/gateways/gateway_rel2_ds.html

  "Oracle Generic Connectivity and Oracle Transparent Gateways provide
   the ability to transparently access data in non-Oracle systems from 
   an Oracle environment....

   ...Oracle Generic connectivity makes it possible to access low-end 
   data stores such as Foxpro, Access, dBase and non-relational targets 
   like Excel. ...

   ...Oracle has transparent gateways to many sources, Sybase, Informix, 
   Microsoft SQL Server, Ingres, Teradata to name a few."

I was mildly disapointed I didn't see PostgreSQL on the list. 1/2 :-) 1/2 :-|
Is this similar to what CONNX does?  

  Ron


Tue, 15 Apr 2003 15:07:07 -0700
"Ron Mayer" <ron@intervideo.com>
Re: Are we losing momentum? 