Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with SELECT

Issue 5140: PostgreSQL doesn't support BULK COLLECT INTO

Include all of the fields from your table in an INTO clause instead.

Issue 5139: PostgreSQL doesn't support FOR UPDATE SKIP LOCKED

Try using FOR UPDATE without SKIP LOCKED.

Issue 5144: PostgreSQL doesn't support FOR UPDATE WAIT clauses

Try using FOR UPDATE without WAIT.

Issue 5586: Automatic conversion for queries with NOCYCLE clause not supported

Perform a manual conversion.

Issue 5126: PostgreSQL doesn't support the MODEL statement

Revise your code. Try using user procedures and temporary tables instead.

Issue 5585: Automatic conversion of an outer join into a correlation query is not supported

Perform a manual conversion.

Issue 5557: PostgreSQL doesn't support GROUPING SETS, CUBE, and ROLLUP functions

These functions can be emulated using CTE expressions instead. GROUPING SETS, CUBE, and ROLLUP functionality is available in PostgreSQL v.9.5 or higher.

Issue 5578: Unable to automatically transform the SELECT statement

The indicated SELECT statement contains language that can't be converted, for example an unsupported function. Try rewriting the statement.