What’s New

The following enhancements are added to the EDB Postgres Migration Portal for this release:

  • With the new filters on the workspace page, you can select one or more filter combinations to refine the information. Also, minor changes have been made to the user interface for a better user experience.

migration portal home page

New Repair Handler

The following repair handler is added to improve the Advance Server compatibility ratio:

  • ERH 2086 - Removes STORE IN (tablespace) clause from PARTITIONED TABLE having PARTITION BY HASH or PARTITION BY RANGE syntax.

    For example:

CREATE TABLE tab (
     a NUMBER,
     d DATE
) PARTITION BY RANGE (d) INTERVAL (NUMTOYMINTERVAL(1,'MONTH')) STORE IN (tbs1);

will become:

CREATE TABLE tab (
     a NUMBER,
     d DATE
) PARTITION BY RANGE (d) INTERVAL (NUMTOYMINTERVAL(1,'MONTH'));

Knowledge Base

The following new knowledge base entries are added; refer to the Knowledge Base section on the Migration Portal for workaround details.

  • Compound Triggers:

    Oracle’s compound triggers are supported in Advanced Server from version 12 onwards. To make it work on earlier versions of Advanced Server, some workaround is required.

  • Explicit Casting:

    Oracle implicitly casts CHARACTER data type to NUMBER when an expression or a numeric value passed is of type CHARACTER. However, in Advanced Server, you must explicitly typecast the expression to a relevant data type.

  • XMLAGG function:

    Oracle uses the XMLAGG function to concatenate multiple row values of a column into a single row. However, in Advanced Server, the STRING_AGG function is used instead of the XMLAGG function.

  • Update Subquery:

    Oracle supports subquery in the UPDATE statement. However, in Advanced Server, Common Table Expression is used to support subquery in the UPDATE statement.