Postgresql nested stored procedure

Vote count:

0

What happens with database transaction if to call one stored procedure inside another stored procedure in PostgreSQL? For example I have stored procedures (function) A and B.

CREATE OR REPLACE FUNCTION A
...
BEGIN
   select B;
   select B;
   select B;
END
$BODY$
LANGUAGE plpgsql

Will B executed using own transaction? If so, how to pass transaction from A to B to run all B inside of one global transaction.

asked 2 mins ago

Alex

6,538

Postgresql nested stored procedure