Re: Deletion

Поиск
Список
Период
Сортировка
От David G Johnston
Тема Re: Deletion
Дата
Msg-id CAKFQuwYctMqiMiuo3ipv3dQU6Xf6X5ZGQQnVQvvbno1NoBA-yQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Deletion  (Ramesh T <rameshparnanditech@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Devrim Gündüz
Дата:
Сообщение: Re: Help related to Postgresql for RHEL 6.5
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Deletion