Re: PROPOSAL - User's exception in PL/pgSQL

On Thu, 16 Jun 2005, Josh Berkus wrote:

> Pavel,
>
> >  o User can specify SQLSTATE only from class 'U1'
> >  o Default values for SQLSTATE usr excpt are from class 'U0'
> >  o Every exception's variable has unique SQLSTATE
> >  o User's exception or system's exception can be raised only with
> >    level EXCEPTION
> >
> > Any comments, notes?
>
> Looks great to me, pending a code examination. Will it also be possible to
> query the SQLSTATE/ERRSTRING inside the EXCEPTION clause? i.e.
>
> WHEN OTHERS THEN
> RAISE NOTICE '%',sqlstate;
> ROLLBACK;

yes, ofcourse. CVS can it now

>
> That's something missing from 8.0 exception handling that makes it hard to
> improve SPs with better error messages.
>
>