Re: PL/PgSQL: EXIT USING ROLLBACK

Поиск
Список
Период
Сортировка
От Marko Tiikkaja
Тема Re: PL/PgSQL: EXIT USING ROLLBACK
Дата
Msg-id 53D3F30E.7020400@joh.to
обсуждение исходный текст
Ответ на Re: PL/PgSQL: EXIT USING ROLLBACK  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: PL/PgSQL: EXIT USING ROLLBACK  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 7/26/14, 8:22 PM, Tom Lane wrote:
> In particular, what happens if someone attaches USING ROLLBACK
> to an EXIT that does not lead from inside to outside a BEGIN/EXCEPTION
> block?

I'm not sure which case you're envisioning.  A label is required, and 
the label must be that of a BEGIN block with an EXCEPTION block if USING 
ROLLBACK is specified.  If that doesn't answer your question, could try 
and explain (perhaps in the form of an example) which problem you're seeing?


.marko



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PL/PgSQL: EXIT USING ROLLBACK
Следующее
От: Marko Tiikkaja
Дата:
Сообщение: PL/PgSQL: RAISE and the number of parameters