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

From Neil Conway
Subject Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support
Date
Msg-id 42954493.6030505@samurai.com
Whole thread Raw
In response to Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support which sets these values  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pgsql: Add PL/pgSQL SQLSTATE and SQLERRM support  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
List pgsql-committers
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.

-Neil

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql: Minor cleanup for recent SQLSTATE / SQLERRM patch: spell
Next
From: Neil Conway
Date:
Subject: Re: pgsql: Minor cleanup for recent SQLSTATE / SQLERRM