Re: ROLLBACK in a function?

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: ROLLBACK in a function?
Дата
Msg-id m3brxmu5f8.fsf@varsoon.wireboard.com
обсуждение исходный текст
Ответ на ROLLBACK in a function?  (Rory Campbell-Lange <rory@campbell-lange.net>)
Ответы Re: ROLLBACK in a function?  (Rory Campbell-Lange <rory@campbell-lange.net>)
Список pgsql-general
Rory Campbell-Lange <rory@campbell-lange.net> writes:

> I understand that functions provide an implied transaction in
> PostgreSQL.

Not quite.  Every SQL statement is executed in its own transaction if
BEGIN/END are not explicitly used.  A statment may cause zero, one or
many function calls, but they will all execute in that transaction.

> Does that mean one can ROLLBACK/COMMIT within the body of a
> function?

Not in current versions.

-0Doug

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

Предыдущее
От: Ewald Geschwinde
Дата:
Сообщение: Re: Triggers and Function's
Следующее
От: Hadley Willan
Дата:
Сообщение: Re: Can anybody recommend an IDE for writing SQL/PLPSQL