From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Łukasz Jarych <jaryszek(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Create event triger |
Date: | 2018-07-10 09:24:59 |
Message-ID: | CAECtzeXPKPyznmATgv_vSKRrFPX2Bqa60kiAXf=EinrtJiYbaA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2018-07-10 10:56 GMT+02:00 Łukasz Jarych <jaryszek(at)gmail(dot)com>:
> No possible?
>
>
Nope, you need to set up the trigger on each table.
Jacek
>
> pon., 9 lip 2018 o 13:03 Łukasz Jarych <jaryszek(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Łukasz Jarych | 2018-07-10 09:28:09 | Re: Create event triger |
Previous Message | Łukasz Jarych | 2018-07-10 08:56:52 | Re: Create event triger |