Skip site navigation (1) Skip section navigation (2)

Post Gres triggers for trail

From: "Mandar M Bhosale" <mbhosale(at)cybage(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Post Gres triggers for trail
Date: 2005-04-25 14:35:51
Message-ID: JAEOKPNNJAEFOLDGJAFFGEODCEAA.mbhosale@cybage.com (view raw or flat)
Thread:
Lists: pgsql-admin
I have difficulty in setting a trigger to have trail of my project

I need to update the modified_date of my database tables through trigger as

CREATE OR REPLACE TRIGGER taril_trigger AFTER UPDATE ON test_trigger FOR
EACH ROW
EXECUTE PROCEDURE pro_trail();

pro_trail(){
BEGIN
NEW.modified_date=(select current_timestamp)
return NULL;
END;
}

Can anybody help me out!!!
Mandar  M. Bhosale

pgsql-admin by date

Next:From: Tom LaneDate: 2005-04-25 15:07:56
Subject: Re: postmaster stop hangs
Previous:From: Michael FuhrDate: 2005-04-25 14:04:04
Subject: Re: PL/SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group