From: Kaloyan Iliev <news1@faith.digsys.bg>
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Triggers
Date: Mon, 21 Aug 2006 15:19:08 +0300
Message-ID: <44E9A4BC.2040309@faith.digsys.bg> (raw)
In-Reply-To: <55c095e90608210503h530a53b6rc49113e379e3d466@mail.gmail.com>
References: <55c095e90608210503h530a53b6rc49113e379e3d466@mail.gmail.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: news1@faith.digsys.bg, ezequias.rocha@gmail.com
Subject: Re: Triggers
In-Reply-To: <44E9A4BC.2040309@faith.digsys.bg>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox