Create Rule/trigger
Create Rule/trigger
От:
"Anagha Joshi" <ajoshi@nulinkinc.com>
Дата:
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 <peter_e@gmx.net>
Дата:
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