>
> 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
> 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