Re: Deletion

On Thu, Aug 28, 2014 at 9:59 AM, Ramesh T [via PostgreSQL] <
ml-node+s1045698n5816744h88(at)n5(dot)nabble(dot)com> 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..
> 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: http://postgresql.1045698.n5.nabble.com/Deletion-tp5816588p5816764.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.