Re: Last modification time

Johan Vromans <jvromans@squirrel.nl> writes:

> Doug McNaught <doug@mcnaught.org> 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