Tom,
> The best way to achieve the effect you want is probably with a BEFORE
> INSERT OR UPDATE trigger that explicitly sets NEW.modify_when = now().
> Having done that, you don't need either the default or the check,
> because there is no way to override the trigger's action (except with
> another trigger).
Did so. Works. Thanks.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346