Menu
AWS Schema Conversion Tool
User Guide (Version 1.0)

Conversion Issues with TRIGGERS

Issue 5313: PostgreSQL doesn't support the action-type clause

Use another method for this functionality.

Issue 5415: PostgreSQL doesn't support system triggers

Revise your code to replace system triggers with another solution.

Issue 5311: PostgreSQL doesn't support system triggers

Revise your code to replace system triggers with another solution.

Issue 5242: PostgreSQL doesn't support COMPOUND TRIGGER

Create a single trigger for each part of the compound trigger.

Issue 5241: PostgreSQL doesn't support the FOLLOWS | PRECEDES clause

Try using the FOR EACH ROW trigger.

Issue 5240: PostgreSQL doesn't support triggers on nested table columns in views

Revise your code to replace the nested table with another solution.

Issue 5238: PostgreSQL doesn't support the REFERENCING clauses

Modify references to pseudo-rows to use OLD and NEW instead.

Issue 5317: PostgreSQL doesn't support the PARENT referencing clause

Use another method for this functionality.

Issue 5306: Transformation from invalid trigger

Check the original trigger for errors, and perform the conversion again.

Issue 5556: PostgreSQL doesn't support conditional predicates

Revise your code and try using simple triggers instead.