Technical Update for EDB Postgres Migration Portal 2.5.0

• Enhanced filters on workspace page along with minor UI changes

New Repair Handler

• 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);
  
  would become
  CREATE TABLE tab (
       a NUMBER,
       d DATE
  ) PARTITION BY RANGE (d) INTERVAL (NUMTOYMINTERVAL(1,'MONTH'));

Knowledge Base

• 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 need to 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.