On Mon, Aug 12, 2013 at 12:46 PM, Arvind Singh <arvin...@hotmail.com> wrote:
> Hello friends, > > I have a table with the following structure > > > Create table postablestatus > > ( > > tablename varchar(30) NOT NULL, > > updatetime timestamp, > > reccount int, > > size int, > > CONSTRAINT postablestatus_pkey PRIMARY KEY(tablename) > > ) WITH (oids = false); > > > where > a) tablename - is the name of table where a record is inserted,updated or > deleted > b) updatetime - the time when table was updated (w/o timezone) > c) reccount - records in table > d) size - bytesize of the table > > -- > for example, if a table called item_master had 1 record and a > new record is inserted and it's size is 2000 bytes > > > postablestatus must have a entry like > > item_master 08/12/2013 12:40:00 2 2000 > -- > > I request to know how to write a trigger in PLSQL so that the > postablestatus > is updated whenever a record is inserted,updated or deleted in item_master > > PLEASE NOTE : a new record must be created if the item_master is not > present in postablestatus > > > You will get more information from below link for creation of audit trigger: http://wiki.postgresql.org/wiki/Audit_trigger Thanks & Regards Raghu Ram
