Recursive Stored Procs? - Mailing list pgsql-general

From Ben
Subject Recursive Stored Procs?
Date
Msg-id 1048966420.28432.7628.camel@purple
Whole thread Raw
Responses Re: Recursive Stored Procs?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Does postgres support recursive stored procs? I thought I remember
reading in the docs a while back that it didn't, but now I can't find
any mention one way or another.

If they are supported, how do transactions work? For example, say A
calls B followed by C, and C has an error. I assume C is automatically
aborted. While A can detect if C failed and also abort, what about the
changes B made? If the call to A starts the transaction and the exit of
A commits or aborts, then that's cool, but if each call gets its own
transaction, that would make things difficult.


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: pg_dump data and foreign keys
Next
From: "Daniel R. Anderson"
Date:
Subject: Re: Database files - personal curiosity