Re: [GENERAL] Data change logs

2004-05-20 Thread Mike Nolan
> > insert into _log select * from where keyfield = NEW.keyfield; Oops, that should be OLD.keyfield. -- Mike Nolan ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister Your

Re: [GENERAL] Data change logs

2004-05-20 Thread Mike Nolan
> So, if anyone out there has an effective alternative, I would love to > hear about it. The way I do it is to create a copy of the table I want to track and add a text column for the user name and a timestamp column. I then set up an on update trigger on the original table that does the followi