Re: [GENERAL] Implement updated column in all tables

2005-07-07 Thread Scott Marlowe
On Thu, 2005-07-07 at 08:25, Andrus wrote: > I have the following column in all my tables which contains data of last > update of this row: > > updated timestamp without time zone DEFAULT now() NOT NULL, > > Hor to force Postgres to update this column automatically with now() value > every tim

Re: [GENERAL] Implement updated column in all tables

2005-07-07 Thread Stephane Bortzmeyer
On Thu, Jul 07, 2005 at 04:25:31PM +0300, Andrus <[EMAIL PROTECTED]> 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 temp