| 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: | Whole Thread | Raw Message | 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 |