Re: Create event triger

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:30:18
Message-ID: CAGv31of+BMyh0sr9PKOWrqFNRXd0hBpEDM+VCm=5mi8q8pe11g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Maybe yes,

but for me when i am learning it is not...

Best,
Jacek

wt., 10 lip 2018 o 11:29 Guillaume Lelarge <guillaume(at)lelarge(dot)info>
napisał(a):

> 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.
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2018-07-10 10:05:09 Re: Create event triger
Previous Message Guillaume Lelarge 2018-07-10 09:29:38 Re: Create event triger