2018-07-10 10:56 GMT+02:00 Łukasz Jarych <jaryszek@gmail.com>:No possible?Nope, you need to set up the trigger on each table.Jacekpon., 9 lip 2018 o 13:03 Łukasz Jarych <jaryszek@gmail.com> napisał(a):Hi,i have small database and i am tracking changes using trigger:CREATE TRIGGER t BEFORE INSERT OR UPDATE OR DELETE ON t_trig FOR EACH ROW EXECUTE PROCEDURE change_trigger(); It is possible to create general trigger for all tables?Like event trigger?It would be very helpful for me. Now i have to set up this trigger on each table.Best,Jacek -- Guillaume.
No possible?
Jacekpon., 9 lip 2018 o 13:03 Łukasz Jarych <jaryszek@gmail.com> napisał(a):Hi,i have small database and i am tracking changes using trigger:CREATE TRIGGER t BEFORE INSERT OR UPDATE OR DELETE ON t_trig FOR EACH ROW EXECUTE PROCEDURE change_trigger(); It is possible to create general trigger for all tables?Like event trigger?It would be very helpful for me. Now i have to set up this trigger on each table.Best,Jacek
Hi,i have small database and i am tracking changes using trigger:CREATE TRIGGER t BEFORE INSERT OR UPDATE OR DELETE ON t_trig FOR EACH ROW EXECUTE PROCEDURE change_trigger(); It is possible to create general trigger for all tables?Like event trigger?It would be very helpful for me. Now i have to set up this trigger on each table.Best,Jacek
CREATE TRIGGER t BEFORE INSERT OR UPDATE OR DELETE ON t_trig FOR EACH ROW EXECUTE PROCEDURE change_trigger();
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных