On Thursday 27 April 2006 09:29 am, Verena Ruff <lists(at)triosolutions(dot)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.