Re: how to rollback transactions in a function?

Поиск
Список
Период
Сортировка
От PGMailList
Тема Re: how to rollback transactions in a function?
Дата
Msg-id 001701c1f293$edf2a120$05faa8c0@edios
обсуждение исходный текст
Ответ на how to rollback transactions in a function?  ("V R" <varadha24@hotmail.com>)
Список pgsql-novice
To rollback the transaction
either call
 
if NOT (YourFunctionThatReturnsBool) then
ROLLBACK;
 
or
raise exception ''you error here'';
 
PostgreSQL GUI
 
 
----- Original Message -----
From: V R
Sent: Tuesday, April 02, 2002 10:49 AM
Subject: [NOVICE] how to rollback transactions in a function?

Hi,
   I  have written a parent function, which inturn, calls 2-3 child functions  that either insert or update rows in  tables .The problem I face is when one of these child functions fail to update or  insert and return False.So in this scenario how do I rolback the transactions made by the earlier child functions ? Any feedback regarding this will be helpful.
 
Thanks
Radha


Send and receive Hotmail on your mobile device: Click Here

В списке pgsql-novice по дате отправления:

Предыдущее
От: "V R"
Дата:
Сообщение: how to rollback transactions in a function?
Следующее
От: Dave Dartnall
Дата:
Сообщение: Formatted printing output