From: | "Ezequias Rodrigues da Rocha" <ezequias(dot)rocha(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Triggers |
Date: | 2006-08-21 12:03:10 |
Message-ID: | 55c095e90608210503h530a53b6rc49113e379e3d466@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi list,
I am planning to generate a trigger to each [update or delete or insert] on
my database to register all moviment on my base (current_user, when, action,
user).
I notice that the trigger is able put a procedure in action but as I have
more than 20 tables I would like to use only one trigger to solve my
problem. Is that possible ?
Now my trigger is working well but I do not want to make 26 triggers and 26
functions.
Is there any people that can help me with this question ?
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Kaloyan Iliev | 2006-08-21 12:19:08 | Re: Triggers |
Previous Message | Andrew Sullivan | 2006-08-21 10:27:17 | Re: NULL becomes default |