| 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: | Whole Thread | Raw Message | 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 |