Re: [SQL] Triggers

2006-08-21 Thread Kaloyan Iliev
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 de

[SQL] Triggers

2006-08-21 Thread Ezequias Rodrigues da Rocha
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 tri

Re: [SQL] NULL becomes default

2006-08-21 Thread Andrew Sullivan
On Sun, Aug 20, 2006 at 11:34:48AM +0100, Julian Scarfe wrote: > So thinking about this a little more, it requires me to be able to change a > column value to DEFAULT (unless I implement the default from scratch in the > trigger, but that feels messy). I don't have much experience of triggers: