Re: [GENERAL] Is it possible to use an EVENT TRIGGER to validate a TRIGGER?

2016-07-06 Thread Luís Eduardo Oliveira Lizardo
Hi Álvaro, thanks for your reaponse. Can you please give me a small example showing how to do this, or more hints? Thanks in advance, Luis Lizardo On Jul 6, 2016 00:02, "Alvaro Herrera" wrote: > Luís Eduardo Oliveira Lizardo wrote: > > Hi, > > > > Is it poss

[GENERAL] Is it possible to use an EVENT TRIGGER to validate a TRIGGER?

2016-07-05 Thread Luís Eduardo Oliveira Lizardo
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: CREATE TRIGGER mytrigger AFTER INSERT OR UPDATE ON mytable FOR EACH STAT