Re: Trigger to update table info

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: Arvind Singh <arvindps(at)hotmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Trigger to update table info
Date: 2013-08-12 09:31:53
Message-ID: CALnrrJSiTzsvV=NhaP4Cod3w6uR8gqWXinHoJ6FmMgRn532fpQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 12, 2013 at 12:46 PM, Arvind Singh <arvindps(at)hotmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ascot.moss@gmail.com 2013-08-12 10:34:23 Recovery.conf PITR by recovery_target_time
Previous Message Seref Arikan 2013-08-12 08:35:10 Re: Pl/Python runtime overhead