From: | Oscar Rodriguez Fonseca <info(at)vraniscci(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: error handling |
Date: | 2006-04-27 15:28:08 |
Message-ID: | 20060427172808.5d4dbe9b@vrlap.localvrnet |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> --> 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?
> I believe that a UNIQUE constraint will stop the insert before any trigger
> ever fires. Maybe someone else knows for sure.
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.
http://www.postgresql.org/docs/8.1/static/sql-createtrigger.html
--
Oscar
From | Date | Subject | |
---|---|---|---|
Next Message | Christian Hofmann | 2006-04-27 16:49:41 | Getting the indexes of a table |
Previous Message | Terry Lee Tucker | 2006-04-27 14:16:33 | Re: error handling |