Skip site navigation (1) Skip section navigation (2)

Nesting Stored Procedure Calls

From: Larry White <ljw1001(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Nesting Stored Procedure Calls
Date: 2004-11-24 16:17:26
Message-ID: d15ea14a0411240817360a3db1@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Is it possible for one stored procedure to call another?  I would like
certain procs to call a different proc to update an audit trail
whenever they're executed.

I thought about using triggers but want the trail to include info
that's not in the updated table -  specifically the application user
ID of the responsible party.

Responses

pgsql-general by date

Next:From: Hunter HillegasDate: 2004-11-24 16:25:39
Subject: Re: Copying into Unicode - Correcting Errors
Previous:From: Peter EisentrautDate: 2004-11-24 16:11:54
Subject: Re: PostGreSQL upgrade failed (Debian Packages), need advice...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group