Add GET STACKED DIAGNOSTICS plpgsql command to retrieve exception info.
This is more SQL-spec-compliant, more easily extensible, and better
performing than the old method of inventing special variables.
Pavel Stehule, reviewed by Shigeru Hanada and David Wheeler
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/3d4890c0c5d27dfdf7d1a8816d7bdcdba3c39d21
Modified Files
--------------
doc/src/sgml/plpgsql.sgml | 121 +++++++++++++++++++++++++++++----
src/backend/utils/errcodes.txt | 55 +++++++++-------
src/pl/plpgsql/src/gram.y | 89 +++++++++++++++++++++++-
src/pl/plpgsql/src/pl_exec.c | 71 ++++++++++++++++++--
src/pl/plpgsql/src/pl_funcs.c | 47 ++++++++-----
src/pl/plpgsql/src/pl_scanner.c | 7 ++
src/pl/plpgsql/src/plpgsql.h | 11 +++-
src/test/regress/expected/plpgsql.out | 75 ++++++++++++++++++++
src/test/regress/sql/plpgsql.sql | 70 +++++++++++++++++++
9 files changed, 480 insertions(+), 66 deletions(-)