What’s New

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

  • Updates have been made to the new UI for a better user experience.

New Repair Handlers

The following repair handlers are added to improve the Advance Server compatibility ratio:

  • ERH 2077 - Removes USING INDEX REVERSE clause from CREATE TABLE statement.

    For example, CREATE TABLE TAB1(ID INT, CONSTRAINT PK_ID PRIMARY KEY(ID) USING INDEX REVERSE); would become CREATE TABLE TAB1(ID INT, CONSTRAINT PK_ID PRIMARY KEY(ID));

  • ERH 2078 - Converts PIPELINED clause in packaged pipelined functions to SETOF RECORD.

    For example, CREATE OR REPLACE EDITIONABLE PACKAGE MSCH.MPKG IS FUNCTION m_fn(p_2 IN VARCHAR2) RETURN m_typ_tab_t PIPELINED;END; would become CREATE OR REPLACE PACKAGE MSCH.MPKG IS FUNCTION m_fn(p_2 IN VARCHAR2) RETURN SETOF RECORD; END;

  • ERH 2079 - Converts GLOBAL PARTITIONED index to LOCAL index.

For example, CREATE INDEX s1.i1 ON s1.t1 (a)        GLOBAL PARTITION BY HASH (a) (PARTITION "Q1" ,  PARTITION "Q2"); would become CREATE INDEX s1.i1 ON s1.t1 (a) LOCAL (PARTITION "Q1" , PARTITION "Q2");

Knowledge Base

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

  • Empty string as a default value for Numeric Datatype:

    Oracle allows an empty string (‘’) as a default value for numeric data type columns. However, Advanced Server does not allow empty strings as a default value for numeric data type columns.

  • TO_DATE function with different datatype arguments:

    Oracle allows the first parameter as a date data type in the to_date function. However, in Advanced Server both parameters must be of data type text (i.e. to_date(text, text)).

  • ROUND function with different datatype arguments:

    In Oracle, both parameters are of a numeric data type for the ROUND function. However, in Advanced Server the first parameter is of numeric data type and the second is of the integer data type.