On Tue, 5 Feb 2002, Tom Lane wrote:
> Marc Lavergne <mlavergn@richlava.com> writes:
> > This would involve far more than just a SQL*Net listener. Given the the
> > syntactic differences between Oracle and PostgreSQL, a whole
> > compatibility layer beyond the listener would be needed to allow for
> > interoperability. The listener piece would be relatively small potatoes
> > compared to building an Oracle<>PostgreSQL syntax translator or a
> > compatibility layer (the number of "bug" reports something like this is
> > capable of generating gives me cold sweats).
>
> Yup. There are some people fooling with a more-Oracle-compatible parser
> (eg, Oracle-style outer join syntax) but I fear that just scratches the
> surface of trying to make something that's plug-compatible enough to
> make Oracle users happy.
>
> Still, having a SQL*Net listener would be a step forward, if anyone
> cared to work on it.
>
> regards, tom lane
I have reverse engineered TDS (the MS/Sybase equivalent) so I assume
someone can do the same with SQL*Net/NET8 but that someone won't be me, we
are a Sybase/DB2 shop.
Brian
