Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with BUILT-IN SQL FUNCTIONS

Issue 8811: PostgreSQL doesn't support the %s function

Create a user-defined function.

Issue 8849: PostgreSQL doesn't support the %s function with parameter values %s

Create a user-defined function.

Issue 8850: Some parameter values for the function %s aren't supported

Review the transformed code, and correct it if necessary.

Issue 8851: PostgreSQL doesn't support using aggregate functions in the SELECT list without a GROUP BY clause

In MySQL, it is possible to use an aggregate function on a field in the SELECT list without adding the other fields in the SELECT list to a GROUP BY clause. In PostgreSQL, adding these fields to a GROUP BY clause is required. Perform a manual conversion in this case.

Issue 8854: PostgreSQL doesn't support the %s function with parameters

Perform a manual conversion.