error handling

From: Verena Ruff <lists(at)triosolutions(dot)at>
To: pgsql-novice(at)postgresql(dot)org
Subject: error handling
Date: 2006-04-27 13:29:07
Message-ID: 4450C723.8010606@triosolutions.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

I have a table with an UNIQUE constraint. Is it possible to have
something like a trigger (or error handler) which is called every time
a insert statement would break this constraint? Or in some simple cases
that this record is just dropped silently, without reporting an error?

Tanks in advance,
Verena

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Terry Lee Tucker 2006-04-27 14:16:33 Re: error handling
Previous Message Mark Campbell 2006-04-27 09:19:18 Re: Perl and psql variables