Postgres Pro
Downloads
Home   >   mailing lists

Re: problem in Trigger - Mailing list pgsql-admin

From A.Bhuvaneswaran
Subject Re: problem in Trigger
Date
Msg-id Pine.LNX.4.44.0304091652000.1293-100000@Bhuvan.bksys.co.in
Whole thread Raw
In response to problem in Trigger  ("Ramesh PAtel " <ramesh@banas.guj.nic.in>)
List pgsql-admin
Tree view 
> 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

pgsql-admin by date:

Previous
From: "Ramesh PAtel "
Date:
Subject: problem in Trigger
Next
From: "Gaetano Mendola"
Date:
Subject: Permission on Views