Re: Oracle Porting, Compiere

John Huttley <john@mwk.co.nz> writes:
> This isn't more that a month or two old.

Okay, it wasn't real clear...

> The previous version worried about nested transactions. 

It still should.  I see no prospect that nested xacts will be in 7.4,
and I wouldn't care to bet they'll be in the release or two after ...

On a more positive note:

* NUMERIC does indeed do the unspecified-precision thing.

* If you can't be bothered to rename datatypes, CREATE DOMAIN would serve to provide Oracle-compatible names for
Postgresdatatypes. There is some parse-time overhead associated though.
 

* CREATE OR REPLACE does exist for some object types now --- views and functions for sure, don't recall anything else.

* Postgres *does* do sub-SELECT-in-FROM, which is what I think is meant by the references to embedded views.

* On the outer join syntax issue: PG supports the SQL-standard syntax, which I believe is also supported by recent
Oraclereleases.  Consider migrating away from Oracle's proprietary syntax.
 
        regards, tom lane