Postgres Pro
Downloads
Home   >   mailing lists

Re: Deletion - Mailing list pgsql-general

From David G Johnston
Subject Re: Deletion
Date
Msg-id CAKFQuwYctMqiMiuo3ipv3dQU6Xf6X5ZGQQnVQvvbno1NoBA-yQ@mail.gmail.com
Whole thread Raw
In response to Re: Deletion  (Ramesh T <rameshparnanditech@gmail.com>)
List pgsql-general
Tree view
On Thu, Aug 28, 2014 at 9:59 AM, Ramesh T [via PostgreSQL] <[hidden email]> 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: Re: Deletion
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: Help related to Postgresql for RHEL 6.5
Next
From: Adrian Klaver
Date:
Subject: Re: Deletion