On 8/25/09 9:18 AM, Melvin Davidson wrote:
>
>
> It would really be nice if pg_class were altered to add two new columns:
> relcreatedat & relmoddat.
I don't think that altering pg_class would really cover all the various
cases of what people want for auditing functionality.
It would be more us
On Tue, Aug 25, 2009 at 11:18 AM, Melvin
Davidson wrote:
>
> This would be very useful for user tables that are meant to exist for only a
> specific length of time. eg: 1 month.
>
that's a weird concept
>
> Likewise, relmoddat would be useful for determining when someone made
> changes to a tabl
It would really be nice if pg_class were altered to add two new columns:
relcreatedat & relmoddat.
Both would be of type timestamp. relcreatedat would contain the timestamp the
object was created.
Likewise, relmoddat would contain the last timestamp the object was altered /
modified.
This would