Re: [GENERAL] Nesting Stored Procedure Calls

2004-11-24 Thread Tino Wildenhain
Hi, Am Mittwoch, den 24.11.2004, 11:17 -0500 schrieb Larry White: > Is it possible for one stored procedure to call another? yes. More specifically these are stored functions rather then stored procedures in the M$-like way. Regards Tino ---(end of broadcast)--

Re: [GENERAL] Nesting Stored Procedure Calls

2004-11-24 Thread Michael Fuhr
On Wed, Nov 24, 2004 at 11:17:26AM -0500, Larry White wrote: > 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. What happened when you tried it? If you're having trouble then it w

Re: [GENERAL] Nesting Stored Procedure Calls

2004-11-24 Thread Joshua D. Drake
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 th

Re: [GENERAL] Nesting Stored Procedure Calls

2004-11-24 Thread Ben
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