Johan Vromans <jvromans@xxxxxxxxxxx> writes: > Doug McNaught <doug@xxxxxxxxxxxx> writes: > >> I would put an AFTER trigger on all the tables concerned that >> inserts a row into an audit table. [...] Audit tables are useful for >> other things too, if you can afford them. > > I think auditing is much too heavy for something simple as finding the > last modification timestamp. Yes, it may be the only alternative, but > a heavy one... Yeah, LISTEN/NOTIFY is definitely a lighter-weight solution--I didn't think of that before. -Doug
