Re: Last modification time - Mailing list pgsql-general

From Johan Vromans
Subject Re: Last modification time
Date
Msg-id m2irrlep4i.fsf@phoenix.squirrel.nl
Whole thread Raw
In response to Re: Last modification time  (Doug McNaught <doug@mcnaught.org>)
Responses Re: Last modification time  (Doug McNaught <doug@mcnaught.org>)
List pgsql-general
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...

-- Johan


pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Sequence skipping values
Next
From: Doug McNaught
Date:
Subject: Re: Last modification time