Re: Any Oracle HSODBC and PostgreSQL experience out there?

Thanks Josh, Elein, David for replies.

On Thu, 2006-04-13 at 16:03 -0700, Josh Berkus wrote:

> You could hack this by extending DBI-Link, although the syntax will be
> awkward ... currently RULES give us no way to grab the WHERE clause
> from an incoming query. So you'd need to do something like:

Am I missing something? I'm trying to query a pg database from within
Oracle... DBI-Link doesn't help with going that direction, right?

I'm surprised at this outcome with HSODBC... I'm new to gateways but I
don't see how HSODBC is useful if you can't push predicates to the
remote side. I realize that this is is non-trivial, but in the
PostgreSQL world it seems like a Fetter Small Magic Plugin (TM) to a
cost-based optimizer might do the trick. Of course, that would not help
the poor sods like me who are occasionally trapped in Obfuscated,
Reprehensible, Arcane, and Crappy Legacy Environment.

-Reece

P.S. A colleague recently showed me
http://www.larsditzel.de/ora_arch.pdf and my response was simply "That's
why I use PostgreSQL".

--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0