On Thu, Aug 28, 2014 at 9:59 AM, Ramesh T [via PostgreSQL] < ml-node+s1045698n5816744...@n5.nabble.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.
