Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B37E0633C70 for ; Thu, 20 Aug 2009 01:29:11 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 01990-01 for ; Thu, 20 Aug 2009 04:29:01 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from renaissance-it.com (mail.renaissance-it.com [164.164.87.55]) by mail.postgresql.org (Postfix) with ESMTP id 8CC036327FB for ; Thu, 20 Aug 2009 01:29:00 -0300 (ADT) Received: (qmail 31478 invoked by uid 109); 20 Aug 2009 04:30:09 -0000 Received: from 192.168.1.6 by Mailsrv (envelope-from , uid 112) with qmail-scanner-1.25st (spamassassin: 3.1.7-deb. perlscan: 1.25st. Clear:RC:1(192.168.1.6):. Processed in 0.046458 secs); 20 Aug 2009 04:30:09 -0000 Received: from unknown (HELO ramasubramanian) (ramasubramanian.g@[192.168.1.6]) (envelope-sender ) by renaissance-it.com (qmail-ldap-1.03) with SMTP for ; 20 Aug 2009 04:30:09 -0000 Message-ID: From: "ramasubramanian" To: "Scott Marlowe" , "Doug Pisarek" Cc: References: <404990009113F448B0DB29FE65110168B2C076@sbs2003.StrataGroup.local> Subject: Re: Call Procedure From Trigger Function Date: Thu, 20 Aug 2009 09:59:20 +0530 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5512 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.739 tagged_above=-10 required=5 tests=BAYES_20=-0.74, STOX_REPLY_TYPE=0.001 X-Spam-Level: X-Archive-Number: 200908/109 X-Sequence-Number: 33018 Yes you can make a procedure call in a trigger function. Example Trigger block { PERFORM Procedure(); } Regards. Ram ----- Original Message ----- From: "Scott Marlowe" To: "Doug Pisarek" Cc: Sent: Thursday, August 20, 2009 9:31 AM Subject: Re: [SQL] Call Procedure From Trigger Function > On Wed, Aug 19, 2009 at 3:53 PM, Doug Pisarek wrote: >> I am in the process of coverting an Oracle 10.2.0.3 database to >> Postgresql >> 8.3. I have a number of triggers in Oracle that make a call to packages. >> I know I will need to re-write the Oracle packages to postgres functions. >> The issue which I have can I make a procedure call from inside a postgres >> trigger function? > > Yep > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >