Thread: keeping track of when a row was last modified
Does postgres automatically keep track of when a row was last modified? Thanks
Nope, although there are plenty of trigger-based examples of doing so in the archives. -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Mar 10, 2005, at 3:15 PM, Sally Sally wrote: > Does postgres automatically keep track of when a row was last modified? > Thanks > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster
On Thu, Mar 10, 2005 at 09:15:28PM +0000, Sally Sally wrote: > Does postgres automatically keep track of when a row was last modified? No, but you can set up a trigger to do it. The "Trigger Procedures" section of the PL/pgSQL chapter in the documentation has an example: http://www.postgresql.org/docs/8.0/interactive/plpgsql-trigger.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/
On Mar 10, 2005, at 4:15 PM, Sally Sally wrote: > Does postgres automatically keep track of when a row was last modified? > Thanks > No. If you look on the SQL list in the past ten-20 minutes, there has been a discussion about this issue. Generally, you can use a trigger to update a timestamp when a row is touched. Sean