On Thu, Jul 07, 2005 at 04:25:31PM +0300, Andrus <noeetasoftspam@xxxxxxxxx> wrote a message of 11 lines which said: > I have the following column in all my tables which contains data of > last update of this row: Me too. > I have about 100 tables and don't like to write 100 triggers. I use a templating engine (Cheetah, http://www.cheetahtemplate.org/ but you are free to use cpp, m4, anything) to manage my SQL files, so it is quite easy to create N triggers, no matter how large N is. I do not know a pure PostgreSQL solution. Remember that the problem is not obvious to solve in a general way. For instance, there are typically fields for which you do not regard a SQL update as a "real" (worthy of recording) update. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
