From: | Łukasz Jarych <jaryszek(at)gmail(dot)com> |
---|---|
To: | guillaume(at)lelarge(dot)info |
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:28:09 |
Message-ID: | CAGv31odH7dh+rbAkQicgP5wAdJyNv6gLSoW=9veEMM-V41fZqg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you very much Guillaume.
Do you know maybe any function to do it automatically?
Best,
Jacek
wt., 10 lip 2018 o 11:25 Guillaume Lelarge <guillaume(at)lelarge(dot)info>
napisał(a):
> 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 | Guillaume Lelarge | 2018-07-10 09:29:38 | Re: Create event triger |
Previous Message | Guillaume Lelarge | 2018-07-10 09:24:59 | Re: Create event triger |