Re: [HACKERS] Feature / Enhancement request.

2009-08-25 Thread Josh Berkus
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

Re: [HACKERS] Feature / Enhancement request.

2009-08-25 Thread Jaime Casanova
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

[HACKERS] Feature / Enhancement request.

2009-08-25 Thread Melvin Davidson
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