OK.. i created a function for delete customer from different tables in single database.i want rollback..my question:where i need to place rollback ,with in a function along with deletion statements..? or after run the function ..?i do not need commit..please let me know..
Functions in PostgreSQL do not have their own transaction environment - they always operate in the transaction of the caller (and cannot control it).
BEGIN;
SELECT function_call();
ROLLBACK;
David J.
View this message in context: Re: Deletion
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
