On Thu, Apr 27, 2006 at 15:29:07 +0200,
Verena Ruff <lists(at)triosolutions(dot)at> wrote:
> 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?
Unique constraints are not deferrable in Postgres. It would be possible to
have a function do the insert and trap errors. I don't know if that will
help in your situation though.