Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

MySQL to PostgreSQL Conversion Reference

BUILT-IN SQL FUNCTIONS

CONTROL FLOW

Item Issue Resolution

CURSORS

Issue 8845: Rows count functionality is not supported behind the "open cursor" statement

Perform a manual conversion.

DECLARE / DEFAULT VALUE

Issue 8826: Check the default value for a Date or DateTime variable

Review generated code and modify it if necessary.

DECLARE / DEFAULT VALUE

Issue 8828: User-defined variables are not supported in PostgreSQL

Perform a manual conversion.

error handling

Issue 8844: Error codes are not the same

You need to check the result of the conversion

error handling

Issue 8846: PostgreSQL doesn't support the statement option %s

Perform a manual conversion.

error handling

Issue 8847: PostgreSQL isn't able to return to a call point after error handling

Perform a manual conversion.

LABEL

Issue 8827: Statement Label Syntax for BEGIN...END blocks is not supported in PostgreSQL

Perform a manual conversion.

PROCESS_LIST

Issue 8856: The information of the server processes is different on different servers

Check your conversion result.

REPLICATION

Issue 8857: Automatic conversion for replication commands is not supported

Perform a manual conversion.

SLEEP

Issue 8853: Perform a manual conversion if using SLEEP() with other expressions

Perform a manual conversion.

CREATE

Item Issue Resolution

Issue 8654: Unable to convert object due to %s not created

Review the %s object.

DATATYPES

Item Issue Resolution

BOOLEAN

Issue 8848: In MySQL the BOOLEAN type is a synonym for TINYINT

Check it when you insert data from a BOOLEAN variables into the database.

DATATYPES

Issue 8706: PostgreSQL doesn't support %s type

To store data of this type in PostgreSQL, use a PostgreSQL-compatible type or use a composite type.

DDL

Item Issue Resolution

CREATE TABLE

Issue 8825: Check the default value for a Date or DateTime column

Review generated code and modify it if necessary.

DROP TABLE

Issue 8801: The table can be locked open cursor

Review your transformed code and modify it if necessary.

DML

Item Issue Resolution

DML

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

Perform a manual conversion.

DML

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

Use DML statement without this option.

DML

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

Use DML statement without this option.

DML

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

Use DML statement without this option.

DML

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

Perform a manual conversion.

DML

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

Perform a manual conversion.

SELECT

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

Use DML statement without this option.

SELECT

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

Use DML statement without this option.

SELECT

Issue 8837: PostgreSQL doesn't support clause STRAIGHT_JOIN

Use DML statement without this option

SELECT

Issue 8838: PostgreSQL doesn't support clause SQL_SMALL_RESULT

Use DML statement without this option

SELECT

Issue 8839: PostgreSQL doesn't support clause SQL_BIG_RESULT

Use DML statement without this option

SELECT

Issue 8840: PostgreSQL doesn't support clause SQL_BUFFER_RESULT

Use DML statement without this option

SELECT

Issue 8841: PostgreSQL doesn't support clause SQL_CACHE

Use DML statement without this option

SELECT

Issue 8842: PostgreSQL doesn't support clause SQL_NO_CACHE

Use DML statement without this option

SELECT

Issue 8843: PostgreSQL doesn't support clause SQL_CALC_FOUND_ROWS

Use DML statement without this option

WHERE

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

Check the string comparison.

EVENTS

Item Issue Resolution

EVENTS

Issue 8855: Automatic conversion of EVENT syntax is not supported

Perform a manual conversion.

EXECUTE

Item Issue Resolution

EXECUTE a character string

Issue 8672: Automatic conversion of this command is not supported

Perform a manual conversion.

Operators

Parser Error

Item Issue Resolution

Parser Error

Issue 8663: Unable to resolve the object

Verify if object %s is present in the database. If it isn't, check the object name or add the object. If the object is present, transform the code manually.

SELECT

Item Issue Resolution

GROUP BY

Issue 8653: PostgreSQL doesn't support the option GROUP BY ROLLUP

Perform a manual conversion.

TRANSACTION

Item Issue Resolution

TRANSACTION

Issue 8807: PostgreSQL doesn't support transactions in functions

Perform a manual conversion.

Unknown

Item Issue Resolution

Issue 8655: This syntactic element conversion is not supported yet

Perform a manual conversion.

Unknown Clause

Issue 8674: Automatic conversion of %s clause of %s statement is not supported

Perform a manual conversion.

VIEW

Item Issue Resolution

CREATE VIEV

Issue 8824: ALGORITHM option is not supported

Perform a manual conversion.