Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with SELECT

Issue 7653: PostgreSQL doesn't support the option GROUP BY ROLLUP. Automatic conversion can't be performed.

Try creating a stored procedure to replace the query.

Issue 7654: PostgreSQL doesn't support the option GROUP BY CUBE. Automatic conversion can't be performed.

Try creating a stored procedure to replace the query.

Issue 7655: PostgreSQL doesn't support the option GROUP BY GROUPING SETS. Automatic conversion can't be performed.

Try creating a stored procedure to replace the query.

Issue 7646: PostgreSQL doesn't support the COLLATE option in the ORDER BY clause. Automatic conversion can't be performed.

You must use the collation settings that were assigned when the database was created.

Issue 7687: PostgreSQL doesn't support the CONTAINS predicate

Perform a manual conversion by re-writing the SELECT statement to use PostgreSQL full-text search functionality instead. For more information about full-text search in PostgreSQL, see Tables and Indexes in the PostgreSQL documentation.

Issue 7688: PostgreSQL doesn't support the FREETEXT predicate

Perform a manual conversion by re-writing the SELECT statement to use PostgreSQL full-text search functionality instead. For more information about full-text search in PostgreSQL, see Tables and Indexes in the PostgreSQL documentation.

Issue 7795: 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.

Issue 7605: PostgreSQL doesn't support the WITH TIES option

Perform a manual conversion of any TOP statements that use the WITH TIES clause. You can use the rank() window function in PostgreSQL to provide similar results.