Re: trapping errors in plpgsql?

CSN wrote:

>I have a table like so:
>id|username|email
>
>with unique indices on username and email. In a
>plpgsql function if an insert fails because of a
>duplicate on one of those fields, is it possible to
>trap the error, figure out which unique fields it
>applies to, and raise a custom error message?
>
>Thanks,
>CSN
>
>
>
>
>__________________________________
>Yahoo! Mail - PC Magazine Editors' Choice 2005
>http://mail.yahoo.com
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match
>
>
>