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