X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 73027476348 for ; Tue, 15 Apr 2003 18:15:38 -0400 (EDT) Received: from torque.intervideoinc.com (mail.intervideo.com [206.112.112.151]) by postgresql.org (Postfix) with ESMTP id A14F947633C for ; Tue, 15 Apr 2003 18:15:37 -0400 (EDT) Received: from ronpc [63.68.5.2] by torque.intervideoinc.com (SMTPD32-5.05) id A949BA00F4; Tue, 15 Apr 2003 15:35:53 -0700 From: "Ron Mayer" To: "Dann Corbit" , "Tom Lane" Cc: "Robert Treat" , "ow" , Subject: Re: Are we losing momentum? Date: Tue, 15 Apr 2003 15:07:07 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 In-reply-to: Importance: Normal X-Spam-Status: No, hits=-11.6 required=5.0 tests=BAYES_20,IN_REP_TO,MSGID_GOOD_EXCHANGE,SMTPD_IN_RCVD autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/532 X-Sequence-Number: 38022 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