Re: Nesting Stored Procedure Calls

Ben wrote:

> 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.)

In 8 you could use an exception in plPgsql I think.

Sincerely,

Joshua D. Drake




>
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend



--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL