X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.225.181]) by svr1.postgresql.org (Postfix) with ESMTP id C2525CB9F5 for ; Sun, 13 Jul 2003 12:04:17 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr5.postgresql.org [64.117.225.181]) (amavisd-new, port 10024) with ESMTP id 67909-02 for ; Sun, 13 Jul 2003 12:04:35 +0000 (GMT) Received: from europa.janwieck.net (h00045a2e4e7c.ne.client2.attbi.com [24.131.181.55]) by svr1.postgresql.org (Postfix) with ESMTP id 8C4F9CB908 for ; Sun, 13 Jul 2003 09:04:15 -0300 (ADT) Received: from Yahoo.com (pD9575330.dip.t-dialin.net [217.87.83.48]) (authenticated) by europa.janwieck.net (8.11.6/8.11.6) with ESMTP id h6DC41c20480; Sun, 13 Jul 2003 08:04:01 -0400 Message-ID: <3F114A7A.2090904@Yahoo.com> Date: Sun, 13 Jul 2003 08:03:06 -0400 From: Jan Wieck Organization: Unorganized User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.2) Gecko/20030208 Netscape/7.02 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Rajesh Kumar Mallah Cc: adivi , pgsql-sql@postgresql.org Subject: Re: trigger proceedures in sql References: <004401c346a5$bbf0bb50$5d0410ac@maximizelearning.com> <200307131201.06850.mallah@trade-india.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.9 tagged_above=0.0 required=5.0 tests=EMAIL_ATTRIBUTION, QUOTED_EMAIL_TEXT, RCVD_FAKE_HELO_DOTCOM_2, RCVD_IN_NJABL, RCVD_IN_OSIRUSOFT_COM, REFERENCES, REPLY_WITH_QUOTES, USER_AGENT_MOZILLA_UA, X_ACCEPT_LANG, X_NJABL_DIALUP X-Spam-Level: * X-Archive-Number: 200307/154 X-Sequence-Number: 14268 Rajesh Kumar Mallah wrote: > > Yes of course! > contrib/dbmirror does execute a procedure written in 'C' > called recordchange() ON update , insert , delete. > If you need help in getting its source lemme know. > > regds > Mallah. > > On Thursday 10 Jul 2003 11:10 am, adivi wrote: >> hi, >> >> can trigger proceedures ( procedures to be executed from within a >> trigger ) not be written in sql. >> >> i was looking for examples and can find proceedures in 'c' only. Trigger procedures can also be written in many procedural languages like PL/Perl, PL/Tcl and PL/pgSQL (what you should be looking at closer). Examples for PL/pgSQL can be found in the regression test. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #