On Wed, Feb 14, 2007 at 06:38:40PM +0200, Andrus wrote: > I need to add the following fields to all tables to existing 8.1 database:
Why redo work? <http://pgfoundry.org/projects/tablelog/> <http://www.postgresql.org/docs/current/static/plpgsql-trigger.html#PLPGSQL-TRIGGER-AUDIT-EXAMPLE> Cheers, D > > > created timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, > > createdby text DEFAULT CURRENT_USER, > > updated timestamp without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL, > > updatedby text -- current_user who last updates this record > > > I need also to add triggers so that updated and updatedby fields ae > automatically set when record is changed. > > > Where to find script which implements this ? > > > Andrus. > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
