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

On Sun, 19 Jun 2005, Neil Conway wrote:

> Pavel Stehule wrote:
> >     DECLARE excpt EXCEPTION [= 'SQLSTATE']
> 
> What would this default to? (i.e. if no '= SQLSTATE' is specified)

I wont to prohibit synonyms in exception (every exception has unique 
sqlstate). If I need better control for sqlstate - exception can leave one 
function I can specify own sql state. If I need only name, its unimportant 
sqlstate value.

> 
> > Rules:
> >  o User can specify SQLSTATE only from class 'U1' 
> >  o Default values for SQLSTATE usr excpt are from class 'U0'
> 

It's my idiot implentation uniques sqlstates. No more ;-)

> Can you elaborate on what you mean?
> 
> >  o Every exception's variable has unique SQLSTATE
> >  o User's exception or system's exception can be raised only with
> >    level EXCEPTION
> 
> It might be worth allowing a custom SQLSTATE to be specified for 
> non-exception RAISEs -- there are already WARNING SQLSTATE error codes 
> (see ERRCODE_WARNING).
> 

Hmm. True. Maybe:
 o System's exception can be raised with relevant level exception.

Regards
Pavel