Erik Jones wrote:
> Am I missing something obvious here? If not, has anyone come up with a
> reliable way to do this?
Triggers on all your tables that append to a logging table?
Have the client do it?
Note that you do *NOT* want to have triggers that attempt to UPDATE a
table to record the last modified time for that table. They'll cause
transactions that touch the same table to block waiting until the first
one commits/rolls back, so they'll ruin your concurrency. They may also
cause unexpected deadlock aborts of transactions.
--
Craig Ringer