From dgp@strata-group.com Wed Aug  19 22:05:43 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 7A37B636656
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 19 Aug 2009 19:05:43 -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 36994-02-4 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 19 Aug 2009 22:05:27 +0000 (UTC)
X-Greylist: delayed 00:11:41.326662 by SQLgrey-1.7.6
Received: from gatekeeper.stratagroup.com (gatekeeper.strata-group.com
	[199.217.206.66])
	by mail.postgresql.org (Postfix) with ESMTP id 8D1B2634E4D
	for <pgsql-sql@postgresql.org>; Wed, 19 Aug 2009 19:05:32 -0300 (ADT)
Received: from mercury.strata-group.com (mercury [131.124.0.23])
	by gatekeeper.stratagroup.com (8.13.1/8.13.1) with ESMTP id
	n7JLo1uZ008870
	for <pgsql-sql@postgresql.org>; Wed, 19 Aug 2009 16:50:01 -0500 (CDT)
Received: from strata-group.com ([131.124.0.8])
	by mercury.strata-group.com (8.14.3/8.14.3) with ESMTP id
	n7JLpSWo015051
	for <pgsql-sql@postgresql.org>; Wed, 19 Aug 2009 16:51:29 -0500 (CDT)
x-mimeole: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
Subject: Call Procedure From Trigger Function
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01CA2117.877F89AD"
Date: Wed, 19 Aug 2009 16:53:41 -0500
Message-ID: <404990009113F448B0DB29FE65110168B2C076@sbs2003.StrataGroup.local>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Call Procedure From Trigger Function
Thread-Index: AcohF4QC1G81XAtIQ+icNZGW6gOCeQ==
From: "Doug Pisarek" <dgp@strata-group.com>
To: <pgsql-sql@postgresql.org>
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, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200908/107
X-Sequence-Number: 33016

This is a multi-part message in MIME format.

------_=_NextPart_001_01CA2117.877F89AD
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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?
=20
Thanks,
Doug P.

------_=_NextPart_001_01CA2117.877F89AD
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.6000.16890" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D827344821-19082009><FONT face=3DArial size=3D2>I am =
in the process=20
of coverting an Oracle 10.2.0.3 database to Postgresql 8.3. I have a =
number of=20
triggers in Oracle that make a call to packages.</FONT></SPAN></DIV>
<DIV><SPAN class=3D827344821-19082009><FONT face=3DArial size=3D2>I know =
I will need=20
to re-write the Oracle packages to postgres functions. The issue which I =
have=20
can I make a procedure call from inside a postgres trigger=20
function?</FONT></SPAN></DIV>
<DIV><SPAN class=3D827344821-19082009><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D827344821-19082009><FONT face=3DArial=20
size=3D2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=3D827344821-19082009><FONT face=3DArial size=3D2>Doug=20
P.</FONT></SPAN></DIV></BODY></HTML>

------_=_NextPart_001_01CA2117.877F89AD--



From scott.marlowe@gmail.com Thu Aug  20 04:01:28 2009
Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 797C9634E98
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	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
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	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 <pgsql-sql@postgresql.org>; Thu, 20 Aug 2009 01:01:17 -0300 (ADT)
Received: by ewy12 with SMTP id 12so4234972ewy.24
	for <pgsql-sql@postgresql.org>; 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: <dcc563d10908192101h73e96c0fr6131308395c47d1a@mail.gmail.com>
Subject: Re: Call Procedure From Trigger Function
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Doug Pisarek <dgp@strata-group.com>
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<dgp@strata-group.com> 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



From ramasubramanian.g@renaissance-it.com Thu Aug  20 04:29:11 2009
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id B37E0633C70
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	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
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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
	<ramasubramanian.g@renaissance-it.com>,
	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 <ramasubramanian.g@renaissance-it.com>)
	by renaissance-it.com (qmail-ldap-1.03) with SMTP
	for <scott.marlowe@gmail.com>; 20 Aug 2009 04:30:09 -0000
Message-ID: <C6A149B8B6FC4391B85BB5B96453FD74@ramasubramanian>
From: "ramasubramanian" <ramasubramanian.g@renaissance-it.com>
To: "Scott Marlowe" <scott.marlowe@gmail.com>,
	"Doug Pisarek" <dgp@strata-group.com>
Cc: <pgsql-sql@postgresql.org>
References: <404990009113F448B0DB29FE65110168B2C076@sbs2003.StrataGroup.local>
	<dcc563d10908192101h73e96c0fr6131308395c47d1a@mail.gmail.com>
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" <scott.marlowe@gmail.com>
To: "Doug Pisarek" <dgp@strata-group.com>
Cc: <pgsql-sql@postgresql.org>
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<dgp@strata-group.com> 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
>