X-Original-To: pgsql-admin@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4F4394762E0; Tue, 8 Apr 2003 15:53:26 -0400 (EDT) Received: from snoopy.oit.edu (snoopy.OIT.EDU [140.211.135.12]) by postgresql.org (Postfix) with ESMTP id 5EE1C4758E6; Tue, 8 Apr 2003 15:53:25 -0400 (EDT) Received: from cvc.net (purvine-141-62.oit.edu [140.211.141.62]) by snoopy.oit.edu (8.12.9/8.12.9/OIT-4.0) with ESMTP id h38JrBGM003931; Tue, 8 Apr 2003 12:53:12 -0700 Message-ID: <3E932937.9000403@cvc.net> Date: Tue, 08 Apr 2003 12:55:35 -0700 From: Dennis Gearon Reply-To: gearond@cvc.net User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.3b) Gecko/20030210 X-Accept-Language: en-us, ru MIME-Version: 1.0 To: Ramesh PAtel Cc: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: [GENERAL] Problem about Triggers and Function References: <3E92FF30.1234.15065BB@localhost> In-Reply-To: <3E92FF30.1234.15065BB@localhost> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-38.8 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_MOZILLA_UA autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/141 X-Sequence-Number: 8296 please give us code and error messages. Ramesh PAtel wrote: > Hi sir, > > I am using PostgreSQL on Redhat Linux 7.3 > > Now i want to create Trigger and Function > I create one trigger but it work only for some Returns. > > but i want to Trigger on table when INSER OR UPDATE any data. then > insert one row in other table related to first table data bye Trigger. > > please if u have Time then u give me one TRIGGER Code. it help me > > Thanking you > > > Ramesh Patel > > ramesh@banas.guj.nic.in > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >