Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with CONTROL FLOW

Issue 7800: PostgreSQL doesn't support result sets in the style of MSSQL

Review your transformed code and modify it if necessary.

Issue 7801: The table can be locked open cursor

In Microsoft SQL Server, a local temporary table created in a stored procedure is dropped automatically when the stored procedure completes. Temporary tables in PostgreSQL are automatically dropped at the end of a session. The conversion uses the DROP TABLE IF EXISTS statement to emulate this behavior and remove the temporary table before the end of the function that created it. In some cases though, this statement might fail because the temporary table is locked due to an open cursor. In this case, the DROP TABLE statement must be commented out. Review your transformed code and modify it if necessary.

Issue 7802: A table that is created within the procedure, must be deleted before the end of the procedure

Review your transformed code and modify it if necessary.

Issue 7826: Check the default value for a DateTime variable

Check the default value for a DateTime variable.

Issue 7628: PostgreSQL doesn't support the GOTO option. Automatic conversion can't be performed.

Revise your code to eliminate GOTO operators, using BEGIN...END blocks in combination with EXIT, REPEAT, UNTIL, and WHILE operators.

Issue 7821: Automatic conversion operator WAITFOR with a variable is not supported

You must perform a manual conversion in cases where you have a WAITFOR DELAY statement that uses a variable, for example WAITFOR DELAY @time;, instead of a literal value, for example WAITFOR DELAY '00:00:05';.

Issue 7691: PostgreSQL doesn't support WAITFOR TIME feature

Perform a manual conversion.