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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Allan Kamau <kamauallan(at)gmail(dot)com>
Cc: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Error handling in PL/PgSQL (without execution termination)
Date: 2010-12-09 05:44:36
Message-ID: AANLkTin2ko_L8ri92yg46LxUmEcsdEU6a1w9Yap-mhxu@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Allan Kamau 2010-12-09 06:00:35 Re: Error handling in PL/PgSQL (without execution termination)
Previous Message Allan Kamau 2010-12-09 04:51:24 Error handling in PL/PgSQL (without execution termination)