Johan Vromans <[EMAIL PROTECTED]> writes: > Doug McNaught <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
