From: | Reece Hart <reece(at)harts(dot)net> |
---|---|
To: | SF PostgreSQL <sfpug(at)postgresql(dot)org> |
Subject: | Re: Any Oracle HSODBC and PostgreSQL experience out there? |
Date: | 2006-04-19 00:43:11 |
Message-ID: | 1145407391.31390.351.camel@tallac.gene.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | sfpug |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2006-04-19 13:53:33 | Re: Any Oracle HSODBC and PostgreSQL experience out there? |
Previous Message | Fred Moyer | 2006-04-14 19:31:33 | Re: Monday's SFPUG ... please RSVP |