Tom Lane wrote:
One interesting point is whether it's possible for one procedure to call
another, and if so what that means for the semantics. Is the inner
procedure allowed to commit a transaction started by the outer one?
Usually yes a procedure can call another, and it's extremely useful to
do so. I'm not so sure about the semantics with transactions, but
personally I wouldn't like to see a procedure be able to commit the
transaction of it's caller.
Peter
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match