Re: Last modification time

From: Johan Vromans <jvromans(at)squirrel(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Last modification time
Date: 2006-02-11 18:17:49
Message-ID: m2irrlep4i.fsf@phoenix.squirrel.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Doug McNaught <doug(at)mcnaught(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2006-02-11 18:42:43 Re: Last modification time
Previous Message Michael Fuhr 2006-02-11 17:59:19 Re: Sequence skipping values