Обсуждение: Create Rule/trigger

Поиск
Список
Период
Сортировка

Create Rule/trigger

От
"Anagha Joshi"
Дата:

Hi All,

Can we create trigger/rule that specifies

Do action Y

      when

          inserts/updates to any table in the database X occurs?

Thx. In advance.

Anagha

Re: Create Rule/trigger

От
Peter Eisentraut
Дата:
Anagha Joshi writes:

> Can we create trigger/rule that specifies
> Do action 'Y'
>         when
>                 inserts/updates to any table in the
> database 'X' occurs?

No, you need to create a trigger/rule for each table.

If you just want to audit things, maybe you could crank up the log level
to log all statements in the server log.

--
Peter Eisentraut   peter_e@gmx.net