Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 797C9634E98 for ; Thu, 20 Aug 2009 01:01:28 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 94985-05 for ; Thu, 20 Aug 2009 04:01:17 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ew0-f216.google.com (mail-ew0-f216.google.com [209.85.219.216]) by mail.postgresql.org (Postfix) with ESMTP id 8A9EF634530 for ; Thu, 20 Aug 2009 01:01:17 -0300 (ADT) Received: by ewy12 with SMTP id 12so4234972ewy.24 for ; Wed, 19 Aug 2009 21:01:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=4jYJ35Cj9CGI5lzXoSlSnyRyHrJOZv51aBvUx6DSjmE=; b=Qx2pksGPq2jy6vIblc2Q3560FdLL4c2KQnafJmhQr6zyJMFgxr4y+2EMwxonBMzMeQ l9kxoMAeLmlMuy4PANiMPApuAC9QZ8jF+mMhRUU5IVITZwOXzZHW/TUnXHuQW7vjbG6l feAsFv2DkTSi5Xp9lOrJVw2giO+ge5BP24QcI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=qflyFB8+98089nNVdG6fay3jDKhs4c66OZ1GX2SL6rlQiCuHfIjNzSShCFpemJ5N8U 08YXZYF+JIhBuOd3Uwzkw637ZNkVqSC487s+Ax+D0/hGnpAT+3E28SJplIdZ4MaleuIh j7vL7zn87wa4Scjd1E1r7MaCD3LZ+RWpNn+zs= MIME-Version: 1.0 Received: by 10.210.68.8 with SMTP id q8mr3547683eba.39.1250740875480; Wed, 19 Aug 2009 21:01:15 -0700 (PDT) In-Reply-To: <404990009113F448B0DB29FE65110168B2C076@sbs2003.StrataGroup.local> References: <404990009113F448B0DB29FE65110168B2C076@sbs2003.StrataGroup.local> Date: Wed, 19 Aug 2009 22:01:15 -0600 Message-ID: Subject: Re: Call Procedure From Trigger Function From: Scott Marlowe To: Doug Pisarek Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.67 tagged_above=-10 required=5 tests=AWL=-0.930, BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 200908/108 X-Sequence-Number: 33017 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