Re: Error handling in PL/PgSQL (without execution termination)

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Error handling in PL/PgSQL (without execution termination)
Дата
Msg-id AANLkTin2ko_L8ri92yg46LxUmEcsdEU6a1w9Yap-mhxu@mail.gmail.com
обсуждение исходный текст
Ответ на Error handling in PL/PgSQL (without execution termination)  (Allan Kamau <kamauallan@gmail.com>)
Ответы Re: Error handling in PL/PgSQL (without execution termination)  (Allan Kamau <kamauallan@gmail.com>)
Список pgsql-general
Hello

http://www.postgresql.org/docs/9.0/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING

Regards

Pavel Stehule

2010/12/9 Allan Kamau <kamauallan@gmail.com>:
> I am searching for the resource that explains how to handle SQL
> related exceptions in PL/PgSQL without letting the function's
> execution terminate.
> I would like to use his to address possible UNIQUE constraint
> violation (and resulting exception) attributed to multiple clients
> concurrently populating the given table.
>
> Allan.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

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

Предыдущее
От: Raimon Fernandez
Дата:
Сообщение: use a variable name for an insert in a trigger for an audit
Следующее
От: Allan Kamau
Дата:
Сообщение: Re: Error handling in PL/PgSQL (without execution termination)