Re: Nesting Stored Procedure Calls

From: Ben <bench(at)silentmedia(dot)com>
To: Larry White <ljw1001(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Nesting Stored Procedure Calls
Date: 2004-11-24 16:27:17
Message-ID: B5391B5C-3E35-11D9-9EFE-000A95BF2A8C@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yes, it's no different than any other select statement. Just keep in
mind that it's all one big happy transaction - if the inner stored proc
aborts, so does the outer one. (Actually, that may have changed in
version 8, but I don't know.)

On Nov 24, 2004, at 8:17 AM, Larry White wrote:

> ne stored procedure to call another? I would like
> certain procs to call a different proc to update an audit trail
> whenever they're exec

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Chille 2004-11-24 16:29:05 Are subselects treated as atomic single commands?
Previous Message Hunter Hillegas 2004-11-24 16:25:39 Re: Copying into Unicode - Correcting Errors