Triggers

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/

Responses

Browse pgsql-sql by date

  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