Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with DELETE

Issue 7623: PostgreSQL doesn't support hints in DELETE statements. The conversion skips options in the format WITH(Table_Hint_Limited).

PostgreSQL doesn't support usings hints (for example, WITH FORCESCAN) to override the default behavior of the query optimizer when executing Data Manipulation Language (DML) statements. Use PostgreSQL methods for performance tuning instead.

Issue 7798: PostgreSQL doesn't support TOP option in the operator DELETE

Perform a manual conversion for any DELETE statements that contain a TOP argument, as in the example following.

Copy
delete top (<expression >)[PERCENT] from <table-name>;

In PostgreSQL, you can use a subquery in the WHERE clause to identify the rows you want to delete.