From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Ben <bench(at)silentmedia(dot)com> |
Cc: | Larry White <ljw1001(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Nesting Stored Procedure Calls |
Date: | 2004-11-24 16:34:59 |
Message-ID: | 41A4B833.9070807@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)commandprompt(dot)com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
Attachment | Content-Type | Size |
---|---|---|
jd.vcf | text/x-vcard | 285 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2004-11-24 16:35:30 | Re: Nesting Stored Procedure Calls |
Previous Message | Joshua D. Drake | 2004-11-24 16:30:03 | Re: PostGreSQL upgrade failed (Debian Packages), need advice... |