Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support - Mailing list pgsql-committers

From Pavel Stehule
Subject Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support
Date
Msg-id Pine.LNX.4.44.0505260918020.29321-100000@kix.fsv.cvut.cz
Whole thread Raw
In response to Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support  (Neil Conway <neilc@samurai.com>)
List pgsql-committers
On Thu, 26 May 2005, Neil Conway wrote:

> Tom Lane wrote:
> > Alternatively we could make them local to any block that contains an
> > EXCEPTION clause, which would fix point 3 and also go a long way towards
> > addressing the unnecessary-overhead gripe.  However that would mean that
> > an attempt to reference them from outside an exception handler would
> > probably fail outright, rather than deliver either NULLs or
> > 00000/"Successful completion".
>
> This behavior sounds fine to me.
>
true, there is not any reason use this variables outside exception
handler.

Pavel


pgsql-committers by date:

Previous
From: Pat
Date:
Subject: Wallstreet Insider
Next
From: Barry@awebbiz.com
Date:
Subject: aWebBiz Newsletter - AdSense Followup