Postgres support (triggers)

[nene]

• [x] CREATE TRIGGER
  • [x] OR REPLACE
  • [x] CONSTRAINT
  • [x] BEFORE | AFTER | INSTEAD OF
  • [x] event [ OR ... ]
  • [x] event types:
    • [x] INSERT
    • [x] UPDATE [ OF column_name [, ... ] ]
    • [x] DELETE
    • [x] TRUNCATE
  • [x] ON table_name
  • [x] FROM referenced_table_name
  • [x] NOT DEFERRABLE | [ DEFERRABLE ] [ INITIALLY IMMEDIATE | INITIALLY DEFERRED ]
  • [x] REFERENCING { { OLD | NEW } TABLE [ AS ] transition_relation_name } [ ... ]
  • [x] FOR [ EACH ] { ROW | STATEMENT }
  • [x] WHEN ( condition )
  • [x] EXECUTE { FUNCTION | PROCEDURE } function_name ( arguments )
• [ ] CREATE EVENT TRIGGER
  • [ ] ON event
  • [ ] WHEN filter_variable IN (filter_value [, ... ]) [ AND ... ]
  • [ ] EXECUTE { FUNCTION | PROCEDURE } function_name()
• [x] ALTER TRIGGER
  • [x] name ON table_name
  • [x] RENAME TO new_name
  • [x] [ NO ] DEPENDS ON EXTENSION extension_name
• [ ] ALTER EVENT TRIGGER
  • [ ] name
  • [ ] DISABLE
  • [ ] ENABLE [ REPLICA | ALWAYS ]
  • [ ] OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
  • [ ] RENAME TO new_name
• [x] DROP TRIGGER
  • [x] IF EXISTS
  • [x] name ON table_name
  • [x] CASCADE | RESTRICT
• [ ] DROP EVENT TRIGGER