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

In response to

Responses

Browse pgsql-general by date

  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