Re: error handling - Mailing list pgsql-novice

From Terry Lee Tucker
Subject Re: error handling
Date
Msg-id 200604271016.33580.terry@esc1.com
Whole thread Raw
In response to error handling  (Verena Ruff <lists@triosolutions.at>)
Responses Re: error handling  (Oscar Rodriguez Fonseca <info@vraniscci.com>)
List pgsql-novice
On Thursday 27 April 2006 09:29 am, Verena Ruff <lists@triosolutions.at> thus
communicated:
--> 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
-->
--> ---------------------------(end of broadcast)---------------------------
--> TIP 6: explain analyze is your friend
-->
I believe that a UNIQUE constraint will stop the insert before any trigger
ever fires. Maybe someone else knows for sure.

pgsql-novice by date:

Previous
From: Verena Ruff
Date:
Subject: error handling
Next
From: Oscar Rodriguez Fonseca
Date:
Subject: Re: error handling