Re: Error handling in PL/PgSQL (without execution termination) - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Error handling in PL/PgSQL (without execution termination)
Date
Msg-id AANLkTin2ko_L8ri92yg46LxUmEcsdEU6a1w9Yap-mhxu@mail.gmail.com
Whole thread Raw
In response to Error handling in PL/PgSQL (without execution termination)  (Allan Kamau <kamauallan@gmail.com>)
Responses Re: Error handling in PL/PgSQL (without execution termination)
List 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 by date:

Previous
From: Raimon Fernandez
Date:
Subject: use a variable name for an insert in a trigger for an audit
Next
From: Allan Kamau
Date:
Subject: Re: Error handling in PL/PgSQL (without execution termination)