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:29:38 |
Message-ID: | CAECtzeWSZZxr1b6tRBh9Ltyt=VRmYJ4obWj5gKQ7W+1fahzseg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2018-07-10 11:28 GMT+02:00 Łukasz Jarych <jaryszek(at)gmail(dot)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,
> 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.
>>
>
--
Guillaume.
From | Date | Subject | |
---|---|---|---|
Next Message | Łukasz Jarych | 2018-07-10 09:30:18 | Re: Create event triger |
Previous Message | Łukasz Jarych | 2018-07-10 09:28:09 | Re: Create event triger |