Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: UNIQUE_VIOLATION exception, finding out which index would have been violated
- From: Michael Fuhr <mike(at)fuhr(dot)org>
- To: Petri Simolin <petrisimolin(at)petrisimolin(dot)com>
- Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
- Subject: Re: UNIQUE_VIOLATION exception, finding out which index would have been violated
- Date: Tue, 25 Sep 2007 01:43:28 -0600
On Tue, Sep 25, 2007 at 04:55:37AM -0200, Petri Simolin wrote: > I have created a function which inserts a row in a table which has 2 unique > indexes on two different columns. > > I am wondering, if there is a way in case of UNIQUE_VIOLATION exception to > find out which index would have been violated? In PL/pgSQL you could extract the constraint name from SQLERRM, which should be a string like 'duplicate key violates unique constraint "foo_id1_key"'. -- Michael Fuhr
- References:
- UNIQUE_VIOLATION exception, finding out which ind ex would have been violated
- From: Petri Simolin
- UNIQUE_VIOLATION exception, finding out which ind ex would have been violated
- Prev by Date: PgpoolAdmin installation
- Next by Date: Re: PgpoolAdmin installation
- Previous by thread: UNIQUE_VIOLATION exception, finding out which ind ex would have been violated
- Next by thread: PgpoolAdmin installation
- Indexes: