Re: problem in Trigger

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: Ramesh PAtel <ramesh(at)banas(dot)guj(dot)nic(dot)in>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: problem in Trigger
Date: 2003-04-09 11:23:51
Message-ID: Pine.LNX.4.44.0304091652000.1293-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> Now i want to Trigger on EMP_TRANS when data INSERT AFTER event
> when insert one row in EMP_TRANS table that time i want to UPDATE column
> EMP_MST.dept_cd with latest value of EMP_TRANS.newdept_cd by TRIGGER.

Follow the below link to learn howto write triggered procedures:

http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=plpgsql-trigger.html

Donot post the same message with different subject in different mailing
list.

regards,
bhuvaneswaran

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2003-04-09 11:52:35 Permission on Views
Previous Message Ramesh PAtel 2003-04-09 09:50:49 problem in Trigger