Re: Last modification time of a database?

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