Re: error handling

From: Verena Ruff <lists(at)triosolutions(dot)at>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: error handling
Date: 2006-05-10 13:35:06
Message-ID: 4461EC0A.9060001@triosolutions.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

sorry for answering so late, ...
> I do not know if there is an specific error handler built in postgresql (besides error-codes).
>
> If you break the unique constraint an error will be thrown. A
> workaround may be to launch a trigger BEFORE the insertion and do whatever is necessary within the trigger.
>
This is possibillity I was thinking of, too. But if there are many
inserts and (probably) only a few of them would break the unique
constraint, there would be a great overhead. This was what I'd like to
avoid with a custom error handler.

Regards,
Verena

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2006-05-10 14:04:14 Re: error handling
Previous Message Verena Ruff 2006-05-10 13:09:36 Re: error handling