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.
>
>
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
