Rollback from function calling another function

Hi,

I have a function "function1" then I have another 2 functions "function2" & "function3". "function2" and "function3" insert records in different tables and a boolean value is returns true if the insert is successfull. "function1" calls the other 2 functions in sequence.

"function1"
DECLARE return_value BOOLEAN;
BEGIN
SELECT * FROM function2() INTO return_value;
SELECT * FROM function3() INTO return_value;
END;

I need to rollback both functions if function3 is unsuccessfull. Can this be achieved cause function2 seems to commit the changes as soon as it finishes.

A function in PostgreSQL can't commit, so function2 cannot commit "on its own".

You are probably running in auto-commit mode.

You need to call all functions inside a transaction then you can commit or rollback everything after the functions are finished.

Could you please give me an example.