pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Doug Pisarek <dgp@strata-group.com>
To: pgsql-sql@postgresql.org
Subject: Call Procedure From Trigger Function
Date: Wed, 19 Aug 2009 16:53:41 -0500
Message-ID: <404990009113F448B0DB29FE65110168B2C076@sbs2003.StrataGroup.local> (raw)

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

view thread (3+ messages)  latest in thread

Message-ID: <404990009113F448B0DB29FE65110168B2C076@sbs2003.StrataGroup.local>
Permalink:  ../404990009113F448B0DB29FE65110168B2C076@sbs2003.StrataGroup.local/
Also on:    postgresql.org/message-id/404990009113F448B0DB29FE65110168B2C076@sbs2003.StrataGroup.local

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: dgp@strata-group.com
  Subject: Re: Call Procedure From Trigger Function
  In-Reply-To: <404990009113F448B0DB29FE65110168B2C076@sbs2003.StrataGroup.local>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox