Error handling in PL/PgSQL (without execution termination)

From: Allan Kamau <kamauallan(at)gmail(dot)com>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Error handling in PL/PgSQL (without execution termination)
Date: 2010-12-09 04:51:24
Message-ID: AANLkTi=aa4f3OBLbOvVAscM2oR+qg5ZeKAOqx1V=SyxN@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2010-12-09 05:44:36 Re: Error handling in PL/PgSQL (without execution termination)
Previous Message Raimon Fernandez 2010-12-09 03:58:55 Re: SELECT is immediate but the UPDATE takes forever