Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with UPDATE

Issue 5064: PostgreSQL doesn't support the UPDATE statement with the ERROR LOG option

You can add error records by inserting them into the log in the exception block. Iterate through the errors in the exception block, add them to the log, and use the EXIT command when finished.

Issue 5558: PostgreSQL doesn't support the UPDATE statement for a PARTITION

Either insert data into the overlying partition, or perform a manual transformation using the UPDATE statement.

Issue 5065: PostgreSQL doesn't support the UPDATE statement for a subquery

Perform this operation on the underlying tables instead.