Message-ID: <44E9A4BC.2040309@faith.digsys.bg>
Date: Mon, 21 Aug 2006 15:19:08 +0300
From: Kaloyan Iliev <news1@faith.digsys.bg>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US;
 rv:1.7.12) Gecko/20060117
MIME-Version: 1.0
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>,
	pgsql-sql@postgresql.org
Subject: Re: Triggers
References: <55c095e90608210503h530a53b6rc49113e379e3d466@mail.gmail.com>
In-Reply-To: <55c095e90608210503h530a53b6rc49113e379e3d466@mail.gmail.com>
Content-Type: text/plain; charset=windows-1251; format=flowed
Content-Transfer-Encoding: 8bit

Hi,
You can use one procedure(function in Postgres) but you have to use 26 
triggers.
Every trigger can call this one procedure to record the information you 
want.

Regards,
   Kaloyan Iliev

Ezequias Rodrigues da Rocha wrote:

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