Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with CURSORS

Issue 7637: PostgreSQL doesn't support GLOBAL CURSORS. Requires manual conversion.

Change the global cursor to a local cursor, or revise your code so it doesn't require global cursors.

Issue 7639: PostgreSQL doesn't support DYNAMIC cursors

Revise your code to remove the DYNAMIC option from any cursors.

Issue 7701: Setting this option corresponds to the typical behavior of cursors in PostgreSQL, so this option is skipped

The FAST_FORWARD option is skipped during conversion, because PostgreSQL cursors provide the same behavior as the FAST_FORWARD option by default. Review your transformed code and modify it if necessary.

Issue 7803: PostgreSQL doesn't support the option FOR UPDATE, so this option is skipped

The FOR_UPDATE option is skipped during conversion because PostgreSQL doesn't support it. Review your transformed code and modify it if necessary.

Issue 7700: The membership and order of rows never changes for cursors in PostgreSQL, so this option is skipped

Use cursors without this option.

Issue 7704: PostgreSQL doesn't support the option OPTIMISTIC, so this option is skipped

Use cursors without this option.

Issue 7702: All PostgreSQL cursors are read-only, so this option is skipped

Use cursors without this option.

Issue 7705: PostgreSQL doesn't support the option TYPE_WARNING, so this option is skipped

Use cursors without this option.