X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4998B53A2C for ; Mon, 25 Apr 2005 11:37:34 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 97293-04 for ; Mon, 25 Apr 2005 14:37:25 +0000 (GMT) Received: from herald.cybage.com (herald.cybage.com [203.199.150.150]) by svr1.postgresql.org (Postfix) with ESMTP id 9A53153A12 for ; Mon, 25 Apr 2005 11:37:23 -0300 (ADT) Received: from MBHOSALE ([192.168.2.109]) by herald.cybage.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 25 Apr 2005 20:05:51 +0530 From: "Mandar M Bhosale" To: Subject: Post Gres triggers for trail Date: Mon, 25 Apr 2005 20:05:51 +0530 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0004_01C549D2.2E41EF40" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-OriginalArrivalTime: 25 Apr 2005 14:35:51.0824 (UTC) FILETIME=[148DF900:01C549A4] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.28 tagged_above=0 required=5 tests=HTML_60_70, HTML_MESSAGE, HTML_TITLE_EMPTY, UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200504/412 X-Sequence-Number: 17425 This is a multi-part message in MIME format. ------=_NextPart_000_0004_01C549D2.2E41EF40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0004_01C549D2.2E41EF40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I have difficulty in setting a trigger = to have=20 trail of my project
 
I need to update the modified_date of = my database=20 tables through trigger as
 
CREATE OR REPLACE TRIGGER taril_trigger = AFTER=20 UPDATE ON test_trigger FOR EACH ROW
EXECUTE PROCEDURE=20 pro_trail();
 
pro_trail(){
BEGIN =
NEW.modified_date=3D(select=20 current_timestamp)
return NULL;
END;
}

Can anybody help me out!!!

Mandar  M. Bhosale

------=_NextPart_000_0004_01C549D2.2E41EF40--