Re: Functions, savepoints, autocommit = I am confused !

Поиск
Список
Период
Сортировка
От Tim Smith
Тема Re: Functions, savepoints, autocommit = I am confused !
Дата
Msg-id CA+HuS5H+_s5vVBqnsYofuO-j0Ya0oApR-KA069tvWF8m_oyFTw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Functions, savepoints, autocommit = I am confused !  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
>
>
> I knew I was missing something:(
> http://www.postgresql.org/docs/9.4/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
>
> "When an error is caught by an EXCEPTION clause, the local variables of the
> PL/pgSQL function remain as they were when the error occurred, but all
> changes to persistent database state within the block are rolled back. As an
> example, consider this fragment:"
>
>
> So I would try



You are a genius.  ;-)

Thank you !

Have a delightful weekend.


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Functions, savepoints, autocommit = I am confused !
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Question about the isolation level and visible