Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: error handling
- From: Bruno Wolff III <bruno(at)wolff(dot)to>
- To: Verena Ruff <lists(at)triosolutions(dot)at>
- Cc: pgsql-novice(at)postgresql(dot)org
- Subject: Re: error handling
- Date: Thu, 27 Apr 2006 14:48:03 -0500
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.
- Follow-Ups:
- Re: error handling
- From: Robert Wimmer
- Re: error handling
- References:
- error handling
- From: Verena Ruff
- error handling
- Prev by Date: Re: Getting the indexes of a table
- Next by Date: 8.1 (win32): partial index not used?
- Previous by thread: Re: error handling
- Next by thread: Re: error handling
- Indexes: