On 08/28/2014 04:22 AM, Ramesh T wrote:
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..
Realized in my last post the below was not entirely clear:
"If you want to invoke an explicit ROLLBACK then you will need an
explicit BEGIN, which means you will need an explicit COMMIT to have the
operation succeed. "
should have been:
If you want to invoke an explicit ROLLBACK when you have a error then
you will need an explicit BEGIN, which means you will need an explicit
COMMIT when the operation succeeds in order for the transaction to
complete.
please let me know..
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general