Re: My function run successfully with cursor, but can't change table

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: My function run successfully with cursor, but can't change table
Дата
Msg-id kp4vll$lis$1@ger.gmane.org
обсуждение исходный текст
Ответ на Re: My function run successfully with cursor, but can't change table  (Kevin Grittner <kgrittn@ymail.com>)
Ответы Re: My function run successfully with cursor, but can't change table  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
Дерево обсуждения 
Kevin Grittner wrote on 10.06.2013 15:19:
> It has nothing to do with the way you are using the cursor; your
> problem is that you are causing an error by attempting to COMMIT
> inside a function (which is not allowed).  This rolls back the
> subtransaction defined by the BEGIN/EXCEPTION block.  You then
> suppress any display of the error with the WHEN OTHERS block.

I thought you could *never* use commit (or rollback) inside a function?

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

Предыдущее
От: Gustavo Amarilla Santacruz
Дата:
Сообщение: Re: Postgresql - Currval Vs Session Pool
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: My function run successfully with cursor, but can't change table