PostgreSQL : How to Handle Multiple Transactions in PostgreSQL

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

Multiple Transactions in PostgreSQL

Note : One Stored Procedure/Function calling multiple stored Procedure/Functions.

Current Situation :

Note: if we are calling multiple stored procedure in one Stored Procedure inside, until complete the execution, before we cannot be able to check the data which is succeed with completed stored procedure, if we any exception occurred in between any of the stored procedure  succeed stored procedure also will rollback.

 

How to handle:

If we are executing nested stored procedure or functions within one SP/Function, with DML operation, if we required succussed stored procedure should do the commit condition.

Do the Commit Condition after stored Procedure?

 

Following below example.

Create or Replace Procedure Multiple_Transaction()

As

$$

Begin

                                    CALL StoredProcedure_1();

                                    Commit;

                                    CALL StoredProcedure_2();

                                    Commit;

                                    CALL StoredProcedure_();

End

$$

Language plpgsql;