Re: Create event triger
От | Guillaume Lelarge |
---|---|
Тема | Re: Create event triger |
Дата | |
Msg-id | CAECtzeWSZZxr1b6tRBh9Ltyt=VRmYJ4obWj5gKQ7W+1fahzseg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Create event triger (Łukasz Jarych <jaryszek@gmail.com>) |
Ответы |
Re: Create event triger
|
Список | pgsql-general |
2018-07-10 11:28 GMT+02:00 Łukasz Jarych <jaryszek@gmail.com>:
Thank you very much Guillaume.Do you know maybe any function to do it automatically?
Nope, but it should be easy to write a shell script or a DO script to do it.
Best,Jacekwt., 10 lip 2018 o 11:25 Guillaume Lelarge <guillaume@lelarge.info> napisał(a):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.
--
Guillaume.
В списке pgsql-general по дате отправления: