Hi,
Is it possible to use an EVENT TRIGGER to validate a TRIGGER definition?
What I want is to guarantee that the trigger is fired AFTER a STATEMENT, on INSERT or UPDATE but not on DELETE, like the following example:
I know I can check those parameters inside the trigger function with TG_OP, TG_WHEN and TG_LEVEL, but in this way, it only checks if the trigger is correct during an insertion, upload or deletion, and not right after the trigger definition.
Is it possible to use an EVENT TRIGGER to validate a TRIGGER definition?
What I want is to guarantee that the trigger is fired AFTER a STATEMENT, on INSERT or UPDATE but not on DELETE, like the following example:
CREATE TRIGGER mytrigger
AFTER INSERT OR UPDATE ON mytable
FOR EACH STATEMENT
EXECUTE PROCEDURE myprocedure();
Best regards,
Luis Lizardo