Re: transactions in plpgsql

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: transactions in plpgsql
Дата
Msg-id 200403191549.27999.dev@archonet.com
обсуждение исходный текст
Ответ на transactions in plpgsql  (Martin Marques <martin@bugs.unl.edu.ar>)
Ответы Re: transactions in plpgsql
Список pgsql-general
On Friday 19 March 2004 13:01, Martin Marques wrote:
> I'm building some functions in plpgsql, and I got to a point where I
> thought: How are transactions used in the function? Is it posible to
> rollback the modifications that were made to the tables at some point in
> the plpgsql function?

You can abort the entire transaction by raising an exception. Nothing more
sophisticated is available at the moment.

There might well be nested transactions in 7.5

--
  Richard Huxton
  Archonet Ltd

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Index selection (and partial index) for BYTEA field
Следующее
От: Steve Krall
Дата:
Сообщение: Re: pg_dump on older version of postgres eating huge