Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with TRANSACTION

Issue 7807: Transactions in functions PostgreSQL doesn't support

Perform a manual conversion to correct this issue.

PostgreSQL supports local transactions within a given client session. You must manually convert Microsoft SQL Server transactions to use the PostgreSQL transaction management statements instead. PostgreSQL doesn't support named or distributed transactions, marking transactions, or transaction management within functions. For more information about using transactions in PostgreSQL, see TRANSACTIONS in the PostgreSQL documentation.