Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with INSERT

Issue 5070: PostgreSQL doesn't support the INSERT 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 5024: PostgreSQL doesn't support the INSERT statement with partition_extension_clause

Perform a manual conversion for the partition types that aren't supported.

Issue 5071: PostgreSQL doesn't support the INSERT statement for a subquery

Perform this operation on the underlying tables instead.

Issue 5090: PostgreSQL doesn't support the INSERT statement for a SUBPARTITION

Either insert data into the overlying partition, or perform a manual conversion using the INSERT statement.