how to use savepoint and rollback in function

Поиск
Список
Период
Сортировка
От tushar nehete
Тема how to use savepoint and rollback in function
Дата
Msg-id AANLkTikBKPa-uvrCsjxkTmEhMbBZf8GeHApKvkZ=Lu_j@mail.gmail.com
обсуждение исходный текст
Ответы Re: how to use savepoint and rollback in function  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Re: how to use savepoint and rollback in function  (dhaval jaiswal <dhavallj@hotmail.com>)
Список pgsql-general
Дерево обсуждения
Hi All,
In Postgresql we can use savepoint and rollback to savepoint in transaction.
But we cannot use savepoint in function.
Currently I am doing migration from Informix to Postgresql 8.4.
In Informix they used Savepoint.
Please advice how to use Savepoint and rollback to savepoint in function.
I know Postgresql has autocommit. But I want to rollback to a particular savepoint.
 
Thanks & Regards,
Tushar

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

Предыдущее
От: "Francisco Figueiredo Jr."
Дата:
Сообщение: Re: [GENERAL] Re: [GENERAL] Different encoding for string values and identifier strings? Or (select 'tést' as tést) returns different values for string and identifier...
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: A join of 2 tables with sum(column) > 30