Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with DML

Issue 8829: PostgreSQL doesn't have an analog of clause ON DUPLICATE KEY UPDATE

Perform a manual conversion.

Issue 8830: PostgreSQL doesn't have an option similar to LOW_PRIORITY for DML statements

Use the DML statement without this option.

Issue 8831: PostgreSQL doesn't have an option similar to IGNORE for DML statements

Use the DML statement without this option.

Issue 8832: PostgreSQL doesn't have an option similar to QUICK for DML statements

Use the DML statement without this option.

Issue 8833: PostgreSQL can't make updates to several tables at the same time

PostgreSQL doesn't support using an UPDATE statement to update several tables at once, for example update Account, Customer set Account.AccountBalance = Account.AccountBalance + 100, Customer.SName = 'Sofan Hubert'. Perform a manual conversion in this case.

Issue 8834: PostgreSQL can't delete from several tables at the same time

PostgreSQL doesn't support using a DELETE statement to delete several tables at once, for example delete table1, table3. Perform a manual conversion in this case.

Issue 8835: PostgreSQL doesn't have an option similar to DELAYED for DML statements

Use the DML statement without this option.

Issue 8836: PostgreSQL doesn't have an option similar to %s for DML statements

Use the DML statement without this option.

Issue 8837: PostgreSQL doesn't support clause STRAIGHT_JOIN

Use the DML statement without this option

Issue 8838: PostgreSQL doesn't support clause SQL_SMALL_RESULT

Use the DML statement without this option

Issue 8839: PostgreSQL doesn't support clause SQL_BIG_RESULT

Use the DML statement without this option

Issue 8840: PostgreSQL doesn't support clause SQL_BUFFER_RESULT

Use the DML statement without this option

Issue 8841: PostgreSQL doesn't support clause SQL_CACHE

Use the DML statement without this option

Issue 8842: PostgreSQL doesn't support clause SQL_NO_CACHE

Use the DML statement without this option

Issue 8843: PostgreSQL doesn't support clause SQL_CALC_FOUND_ROWS

Use the DML statement without this option

Issue 8795: PostgreSQL is case sensitive. Check the string comparison.

Check string comparisons in the WHERE clauses of statements, for example WHERE [Name] LIKE '%BLOCKED%';. All strings used in comparisons must be lowercase.