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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
