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; That's something missing from 8.0 exception handling that makes it hard to improve SPs with better error messages. -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org